GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Concepts
Go To First  |  Previous Question  |  Next Question 
 Concepts  |  Question 29 of 31    Print  
Loading data from Datamarts
Which approach is better and why?Loading data from datamarts to datawarehouse or vice versa?


  
Total Answers and Comments: 3 Last Update: October 10, 2008     Asked by: tanya123 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 05, 2008 08:25:59   #1  
karun_9 Member Since: June 2008   Contribution: 1    

RE: Loading data from Datamarts
i think the best process to load data into dwh from dm is delta processing.

delta processing is ADWH process which capture the changes in source(dm) and transfers the data accordingly with the time stamp to given DWH.

 
Is this answer useful? Yes | No
July 29, 2008 15:50:23   #2  
vivek1708 Member Since: May 2008   Contribution: 18    

RE: Loading data from Datamarts
As per Inmon
best way is to move data from ODS --> Data warehouse and frm there to DataMarts.

 
Is this answer useful? Yes | No
October 09, 2008 12:54:47   #3  
Mehul@DWH Member Since: February 2006   Contribution: 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.


 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape