Data Warehousing Architecture

Review the Enterprise Data Warehouse architecture shown in the figure 1.1 

  [10 % ]

(a) identify all possible architectural issues with detailed explanation? 

(b) Suggest a modification to the architecture, so that we can save 2-4 hours of load time and still will be able to create and run reports (no multi-dimensional analysis)?    

(c) Explain the reasoning behind North American DW as a source to the Global

DW? Is this a right approach based on the concepts we learned?   

For more data storage.