Question
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all.
Explanation
Extract reads the data from the source, the CRM system. Load writes the raw data into the target, the data warehouse. In ELT the transformation also happens in the data warehouse, using the target store's own processing power instead of a separate transformation engine. A separate in-memory data integration tool performing the transform is the ETL pattern, which is the tempting wrong choice here.
