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: An in-memory data integration tool The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.