Question: One reason that data must be transformed before being loaded from the operational database to the data warehouse is that... ( Choose the best answer.
One reason that data must be transformed before being loaded from the operational database to the data warehouse is that... Choose the best
answer.
The operational database is much smaller than the data warehouse.
Most data collected in the operational database is inaccurate and needs to be corrected by hand prior to storage in the data warehouse.
The data in the operational database may use different fields than the data in the data warehouse.
The operational database also includes data from data marts, so these two types of data need to be fused together prior to being loaded to the data warehouse.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
