Fig. 12.1.6 The relational model and the data warehouse.
Data are loaded into the data warehouse from the operational applications. Data in the
operational applications reside in the applications in a denormalized state. Data are
loaded into the data warehouse through technology known as “ETL”
(“extract/transform/load”) technology.
Fig. 12.1.7 shows the loading of data into the data warehouse from the operational
environment, passing through technology known as ETL technology.
Chapter 12.1: Operational Analytics