Explain the difference between ETL and ELT.

Explain the difference between ETL and ELT.

Approach: Compare the sequence of transformation and loading.

ETL (Extract, Transform, Load) transforms data before it reaches the target. ELT (Extract, Load, Transform) loads raw data into the target (like a cloud warehouse) and uses the target's compute power for transformations.

Follow-up: Why is ELT becoming more popular with cloud warehouses?

Key concepts: staging, compute power, data lake.