ETL Process

Guide to Data Warehousing and Business Intelligence

ETL Technology (shown below with arrows) is an important component of the Data Warehousing Architecture.  It is used to copy data from Operational Applications to the Data Warehouse Staging Area, from the DW Staging Area into the Data Warehouse and finally from the Data Warehouse into a set of conformed Data Marts that are accessible by decision makers.

Data Warehousing Environment
Typical Data Warehousing Environment

The ETL software extracts data, transforms values of inconsistent data, cleanses "bad" data, filters data and loads data into a target database.  The scheduling of ETL jobs is critical.  Should there be a failure in one ETL job, the remaining ETL jobs must respond appropriately.

Next Page