Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

What are the Advantages of de normalized data?

3 Answers  

whats the logic to load the lower level of granularity of data to fact table.

0 Answers   IBM,

What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?

5 Answers   TCS,

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,

In which circumstances that informatica server creates Reject files?

2 Answers  

For more Informatica Interview Questions Click Here
Categories