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.
One reason that data must be transformed before

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!