ELT
ELT (Extract, Load, Transform) is a data integration pattern that loads raw data into a destination system first and performs transformation afterward, using the destination's own compute resources.
7 resources across 2 libraries
Glossary Terms(5)
Data Lake
A data lake is a centralized storage repository that holds raw data in its native format — structured, semi-structured, or unstructured — without requiring a p…
ETL
ETL (Extract, Transform, Load) is a data integration process that pulls data from source systems, transforms it into a clean, structured format outside the tar…
ELT
ELT (Extract, Load, Transform) is a data integration pattern that loads raw data into a destination system first and performs transformation afterward, using t…
Change Data Capture (CDC)
Change Data Capture (CDC) is a set of techniques for detecting and capturing row-level inserts, updates, and deletes in a source database as they happen, so th…
Data Lineage
Data lineage is the tracked record of where a piece of data originated, how it has moved and transformed across systems, and where it is ultimately consumed —…
Interview Questions(2)
ETL vs ELT Pipelines: What is the Difference?
ETL (Extract, Transform, Load) transforms data in a separate processing engine before loading it into the target system, while ELT (Extract, Load, Transform) l…
How Would You Design an ETL Pipeline?
An ETL pipeline extracts data from source systems, transforms it into a clean, validated, and correctly shaped form, and loads it into a target store like a wa…