Return to Glossary

Extract, Load, Transform (ELT)

A data integration process that pulls data from one or more source systems, loads it into a target repository, and then transforms it using the repository’s engine. It contrasts with traditional ETL that transforms data in an external server before loading it into a target.

Added Perspectives

Extract-Load-Transform... is a variation on ETL that was conceived to offset some of the latency that results from pure ETL processing. Waiting for all transformation work to complete delays availability of data for business use. Loading immediately after extract, then transforming data in place reduces the delay. ELT has the greatest impact on accelerated data availability when multiple sources that are not ready for extract simultaneously would be held in a staging area with ETL processing. With ELT the data warehouse serves the role of data staging so each source becomes available for use upon extraction and loading. Data transformation is performed in place in the data warehouse once all sources are loaded. Data quality and data privacy considerations are sometimes a concern with ELT processing. When data is made available for use without transformation, it is widely exposed without first performing data cleansing and sensitive data masking or obfuscation.

- Dave Wells in Data Pipeline Design Patterns

May 6, 2020 (Blog)

Spark can accelerate ETL processing, for example by combining and executing these three tasks (extract, transform and load) in-memory with a single set of coding commands. It also can streamline ELT, meaning the data is extracted, loaded and then transformed once it arrives at the target. In addition, Spark can help discover big data sources, identifying data patterns and classifications, before extraction and/or when they are consolidated at the target.

- Kevin Petrie in Sparking Data Warehouse Modernization

May 6, 2019 (Blog)

Relevant Content

Mar 10, 2016 - In an era of ever increasing volumes of ever dirtier data, the old concepts of data warehouses and ETL offer important lessons, but must be extended far...

Related Terms

Datalere

Providing modern, comprehensive data solutions so you can turn data into your most powerful asset and stay ahead of the competition.

Learn how we can help your organization create actionable data strategies and highly tailored solutions.

© Datalere, LLC. All rights reserved

383 N Corona St
Denver, CO 80218

Careers