difference between top down(w.h inmon)and bottom up(ralph
kimball)approach?

Answer Posted / yours

Hi,

Top Down approach:-

As per W.H.INWON, first we need to build the Datawarehouse after that we need to build up the DataMart but this is so what difficult to maintain the DWH.


Bottom up approach;-


As per Ralph Kimbal, first we need to build up the DataMarts then we need to build up the Datawarehouse ..
this approach is most useful in real time while creating the Datawarehouse.


As per my knowledge i am giving this answer..
Let me know it is corrector not...

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is lookup transformation?

597


what are factless facts? And in which scenario will you use such kinds of fact tables.

1317


Describe the impact of several join conditions and join order in a joiner transformation?

649


tell me the rules and responsblites in our project(my project is development)

1498


What are the types of data warehouses?

944






Explain sessions?

606


Why filter transformation is an active one?

565


generate date / time dimension in informatica

719


Describe expression transformation?

636


Differentiate between a database and data warehouse?

654


Does an informatica transformation support only aggregate expressions?

608


Explain load alternative records / rows into multiple targets - informatica

687


Repository user profiles

1377


What does role playing dimension mean?

630


What is informatica worklet?

612