Glossary Updates16 new terms added to the glossaries · November 12, 2026, 21:23 CET
AI TechDocKnowledge

Glossary · 7 · Product information systems and data roles

ETL and ELT

Also known as: ETL, ELT, Extract, transform, load, Extract, load, transform

ETL (extract, transform, load) and ELT (extract, load, transform) are two patterns for moving data from source systems into a target: ETL transforms the data before loading it, ELT loads it first and transforms it inside the target system.

  • Data management
  • System integration

In one sentence

Two patterns for moving data into a target: ETL transforms data before loading it, ELT loads it first and transforms it in the target.

Example

A nightly ETL job extracts released parts from PLM, maps their attributes and loads them into the spare parts catalog; a change made after the run reaches the catalog a day later.

Explained in context

Context cards connect this term with others to answer one question. Also in British English and German.

How it applies

  • Timing: Batch ETL and ELT runs move data at set times. Between runs, the target holds the state of the last run; documents built from it carry that state.
  • Transformation rules: Mappings, unit conversions and filters in the transform step change values. They belong in the data lineage of every value they touch.
  • Pipelines: ETL and ELT are common building blocks of a data pipeline; event streaming and API calls are alternatives for flows that must be current.

ETL vs. ELT

ETL suits targets that should only receive cleaned, conformed data. ELT suits targets with enough processing power to keep raw data and transform it there, which keeps the raw copy available for later checks.

External references

By knowledge.aitechdoc.world · Published November 10, 2026 · Last reviewed

Source: DAMA International, DAMA-DMBOK: Data Management Body of Knowledge, 2nd edition (2017)

Definitions follow the cited standards and specifications. Where a source is a copyrighted publication, such as an ISO, IEC or EN standard, the definition is a close paraphrase, not a verbatim quotation, so as not to infringe copyright. We recommend reading the original publication. The sections “How it applies” are editorial commentary by AI TechDoc Knowledge and are not part of any standard.

Seen a mistake? Send us a note!