Question

Which store is the intermediary store where transformation of data takes place when moving data to a data warehouse? A. middleware B. load stage C. staging area D. extract stage

Answer 1

I think the answer is A.... middle ware

Answer 2

The staging area is the ‘intermediary store’ where the transformation of data takes place when ‘moving data’ to a ‘data warehouse’.

Option: C

Explanation:

• In the stage of multistage data transformation, the process involved extraction, transformation, and the load process.  

• The extracted data is sent to the staging area where transformation takes place before loading the data into the warehouse.  

• The process of transformation involves the cleansing and aggregation which may be required for the data to prepare it for the analysis.

Learn more about staging area

Staging area comes under which layer?

https://brainly.in/question/389401