Using ELT for cleansing and transforming data
ELT is the modern approach to the older process of extract, transform, and load (ETL), where transformations take place before the data is loaded into the data warehouse. The difference with the extract, load, and transform (ELT) approach is that it allows for cleansing and transformation to happen inside the data warehouse. In this section, we will focus on transformation and cleansing after your data has already been loaded.
Why has ELT gained in popularity over ETL?
ELT is being adopted more frequently due to several advancements in data processing and computing infrastructure. ELT is less complex to manage and can deliver the same results as ETL. Compute resources have become much more accessible, flexible, and cheaper in the past decade, with cloud computing allowing for more data transformation work to be done within the data warehouse. Analytics infrastructure and enterprise data warehouses now run on hyperscaler providers...
