Extract, Transform and Load

#Data Warehouse #ETL

Many organizations are talking about ELT instead of ETL nowadays

ETL Process



  1. Extract: extract data from sources
  2. Transform: transform it to proper format
  3. Load: load it to data storage infrastructure

E for Extract

  1. Should not affect the source system.

T for Transform

  1. Cleaning
  2. Filtering
  3. Enriching
  4. Splitting
  5. Joining

L for Load

Deal with sync and waiting

Published: by ;

Lei Ma (2018). 'Extract, Transform and Load', Datumorphism, 11 April. Available at: https://datumorphism.leima.is/wiki/data-warehouse/extract-transform-load/.

Current Ref:

  • wiki/data-warehouse/extract-transform-load.md