Loading data from Datamarts

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

Questions by tanya123   answers by tanya123

Showing Answers 1 - 12 of 12 Answers

karun_9

  • Jun 5th, 2008
 

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.

  Was this answer useful?  Yes

Mehul@DWH

  • Oct 9th, 2008
 

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions