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.

 

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. 

• Search Site • Predictive Analysis • Create Website • Business Analysis • Systems Analysis • Programming • Site Map •