Typically, ELT takes place during business hours when traffic on the source systems and the data warehouse is at its peak and consumers are waiting to use the data for analysis or otherwise. In this step, the transformed data is moved from the staging area into a data storage area, such as a data warehouse or data lake.įor most organizations, the data loading process is automated, well-defined, continuous and batch-driven.
That said, it is more typically used with unstructured data. The data set can consist of many data types and come from virtually any structured or unstructured source, including but not limited to: Extractĭuring data extraction, data is copied or exported from source locations to a staging area. ELT consists of three primary stages Extract, Load, and Transform.
