Extract, Transform and Load

#Data Warehouse #ETL

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

Published: by ;

Current Ref:

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