data-architecture-a

(coco) #1
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
Free download pdf