In the _____ phase of transferring data from a transactional database to a data warehouse,specialists "cleanse" the data and modify it into a form that allows insertion into the data warehouse.
A)extraction
B)transformation
C)injection
D)loading

Question

Quizplus · Accepted Answer

The extraction phase involves identifying the data to be extracted from the transactional database. The transformation phase involves modifying and "cleansing" the data to ensure it is in a format that can be inserted into the data warehouse. The injection phase is not a commonly recognized phase in this process. The loading phase involves actually inserting the transformed data into the data warehouse. Therefore, the best choice for this question is B (transformation).

In the _____ Phase of Transferring Data from a Transactional