ETL Process

Guide to Data Warehousing and Business Intelligence

ETL Technology (shown below with arrows) is an important component of the Data Warehousing Architecture.

ETL is used to copy data:

  1. from databases used by Operational Applications to the Data Warehouse Staging Area
  2. from the DW Staging Area into the Data Warehouse
  3. from the Data Warehouse into a set of conformed Data Marts

The data marts are then made available to 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