IBM Support

White paper: ETL and Metric Query Troubleshooting

Technical Blog Post


Abstract

White paper: ETL and Metric Query Troubleshooting

Body

In IBM TRIRIGA, ETL scripts are used to periodically take snapshots of the transactional data. These snapshots are time stamped and stored in metric fact tables. Metric queries use the information in the metric fact tables to visually display the information in metric charts. The ETL and Metric Query Troubleshooting white paper describes how to debug common issues with ETL and metric queries. Knowledge of SQL scripts and the IBM TRIRIGA schema is required to debug ETL scripts.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSHEB3","label":"IBM TRIRIGA Application Platform"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11114563