ETL and ELT

Concetti di Data Warehousing

Aaren Stubberfield

Data Scientist

Understanding ETL and ELT names

ETL

  1. Extract
  2. Transform
  3. Load

ELT

  1. Extract
  2. Load
  3. Transform
Concetti di Data Warehousing

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
Concetti di Data Warehousing

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
Concetti di Data Warehousing

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.

Concetti di Data Warehousing

Let's practice!

Concetti di Data Warehousing

Preparing Video For Download...