
Explanation:
Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: The data warehouse
In the ELT pipeline, the transformation occurs in the target data store. Instead of using a separate transformation engine, the processing capabilities of the target data store are used to transform data.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl