Process overview

The Extract, Transform, Load (ETL) process is used to update the operational data to the data warehouse.

The term Extract applies to the process of extracting operational data from the data sources to the staging database. The data is then transformed and filtered using compiled DWD components that are created and stored in the DWD catalog. The transformed data is loaded into dimensions and fact tables in the data warehouse.

The data in the data warehouse is consumed using Live Access.