Manipulating data with the ETL (extract, transform, and load)
framework
During the ETL (extract, transform, and load)
process, data is extracted from various sources, transformed and normalized
through encoded business rules, and then loaded into the fact and
dimension tables of a data mart.
Getting started with the ETL process
To get started with the ETL process of Rational® Common Reporting, you need to prepare the data warehouse, data source connections,
and ETL catalog, and then run the ETL jobs. You can also
configure the ODBC driver, which is used for providing data in relational
form to the ETL framework.