GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Concepts

 Print  |  
Question:  Loading data from Datamarts

Answer: Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?


October 10, 2008 12:54:47 #3
 Mehul@DWH   Member Since: February 2006    Total Comments: 6 

RE: Loading data from Datamarts
 

1. The direction of the data load depends on the approach that was adopted while designing the Warehouse and the datamart. If the top down approach, which Kimbal mentions is used, then data will be moved from DW to DM, whereas if Inmons approach of bottom-up design is used, then data will flow from DM to DW.

2. There is nothing like which one is a better option. Basically the decision of loading data whether from DM to DW, or from DW to DM depends on the design as mentioned above.

     

 

Back To Question