ETL and ELT

Data Warehousing Concepts

Aaren Stubberfield

Data Scientist

Understanding ETL and ELT names

ETL

  1. Extract
  2. Transform
  3. Load

ELT

  1. Extract
  2. Load
  3. Transform
Data Warehousing Concepts

Understanding ETL - Pros and Cons

  • Data transformed during the move
  • Uses separate system to process data

Pros:

  • Lower data storage costs
  • PII security compliance

Cons:

  • Transformation errors/changes require new data pulls
  • Costs of separate system to process data
Data Warehousing Concepts

Understanding ELT - Pros and Cons

  • Data is loaded, then transformed
  • Uses the warehouse to transform the data

Pros:

  • No separate system to process data
  • Transformations can be rerun without impacting source systems
  • Works well for near real-time requirements

Cons:

  • Increased storage needs from raw data
  • Compliance with PII security standards
Data Warehousing Concepts

The cloud and ELT

IT Technician with a Laptop Computer and Black Male Engineer Colleague are Talking in Data Center while Walking Next to Server Racks.

Data Warehousing Concepts

Let's practice!

Data Warehousing Concepts

Preparing Video For Download...