ETL and ELT

Các khái niệm về Kho dữ liệu (Data Warehouse)

Aaren Stubberfield

Data Scientist

Understanding ETL and ELT names

ETL

  1. Extract
  2. Transform
  3. Load

ELT

  1. Extract
  2. Load
  3. Transform
Các khái niệm về Kho dữ liệu (Data Warehouse)

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
Các khái niệm về Kho dữ liệu (Data Warehouse)

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
Các khái niệm về Kho dữ liệu (Data Warehouse)

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.

Các khái niệm về Kho dữ liệu (Data Warehouse)

Let's practice!

Các khái niệm về Kho dữ liệu (Data Warehouse)

Preparing Video For Download...