Extract, Transform and Load

Many organizations are talking about ELT instead of ETL nowadays

ETL Process

ETL

ETL

  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

Planted: by ;

No backlinks identified. Reference this note using the Note ID wiki/data-warehouse/extract-transform-load.md in other notes to connect them.

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