Editing Data warehouse (section)

===ELT===
[[File:ELT Diagram.png|thumb|244x244px|[[Extract, load, transform|ELT]]-based data warehouse architecture]]

[[Extract, load, transform|ELT]]-based data warehousing gets rid of a separate [[Extract, transform, load|ETL]] tool for data transformation. Instead, it maintains a staging area inside the data warehouse itself. In this approach, data gets extracted from heterogeneous source systems and are then directly loaded into the data warehouse, before any transformation occurs. All necessary transformations are then handled inside the data warehouse itself. Finally, the manipulated data gets loaded into target tables in the same data warehouse.