The process of retrieving data from multiple sources to be loaded into a data warehouse is called ________.
A)extraction
B)transformation
C)loading
D)normalization

Question

Quizplus · Accepted Answer

The process described in the question is known as data extraction, which involves retrieving data from disparate sources such as databases, applications, and files for the purpose of further analysis. Transformation and loading are the subsequent phases of the ETL (Extract, Transform, Load) process, where the data is processed and prepared for loading into a data warehouse or other target system. Normalization, on the other hand, is a database design technique aimed at reducing data redundancy and improving data consistency. While normalization may be performed as part of the data preparation process in some cases, it is not directly related to the retrieval of data from multiple sources.

The Process of Retrieving Data from Multiple Sources to Be