In which stage of extraction, transformation, and load (ETL) into a data warehouse are data aggregated?
A) transformation
B) extraction
C) load
D) cleanse

Question

Quizplus · Accepted Answer

Data aggregation typically occurs during the transformation stage of the ETL process. During the transformation stage, data from various sources is standardized, cleaned, filtered, and manipulated to ensure that it can be loaded into the data warehouse in a meaningful and useful way. Aggregation is one of the key processes that occurs during this stage, as it involves combining data from multiple sources and summarizing it at a higher level to provide a more comprehensive view of the data.

In Which Stage of Extraction, Transformation, and Load (ETL) into a Data