Question

A retail analytics team is migrating to a cloud data warehouse that offers massive, scalable compute. They want to load raw sales, inventory, and clickstream data into the warehouse as quickly as possible, then use the warehouse's own processing power to clean and transform the data on demand as new analytical needs arise. Which data integration approach best fits this requirement?

Accepted Answer

ELT, because raw data is loaded first and transformations run inside the target warehouse

Answer

ETL, because data must be fully transformed on a staging server before it is loaded

Answer

OLTP, because the warehouse processes many small transactions in real time

Answer

Data federation, because the warehouse queries source systems directly without loading data