1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dinesh

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / usha

top down approach means first dataware house then data
marts... inmons approch

bottom up approach means first datamarts then data ware
house... ralphkimballs approch

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Informatica Interview Questions

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

What is rank transformation?

0 Answers  

What is Target Update Override? What is the Use ?

8 Answers   Patni,

What is informatica etl tool?

0 Answers  




How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

How to call shell scripts from informatica?

0 Answers  

hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  

hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.

5 Answers   TCS,

What is the use of target designer?

0 Answers  

Can we make worklet inside worklet?

1 Answers  

For more Informatica Interview Questions Click Here
Categories