Page 333 - Data Architecture
P. 333
Chapter 8.3: The Data Warehouse/Operational Environment Interface
The problem with the ELT option is that there is the temptation to simply not execute the
“T” step (i.e., the transformation step). In this case, the data warehouse turns into a
“garbage dump.” And once the data warehouse is loaded with garbage, it becomes
worthless as a foundation for decision-making.
If an organization has the will power to not neglect to do the “T” step, then there is
nothing wrong with the ELT approach. But few organizations have the willpower and
discipline to use the ELT approach properly.
Fig. 8.3.7 illustrates the ELT approach to interfacing operational systems and data
warehouses.
Fig. 8.3.7 An alternative to ETL is ELT.
333
