difference between top down(w.h inmon)and bottom up(ralph
kimball)approach?
Answers were Sorted based on User's Feedback
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 |
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 |
How the informatica server sorts the string values in Rank transformation?
How to extract original records at one target & Duplicate records at one target?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
what is runtime variable?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
explan ur project architecture?
Why touse stored procedure in ETL Application?
What is parallel processing in informatica?
how may sources can be used in a mapping at a time?(limit)
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?