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 |
What is meant by active and passive transformation?
What is persistent lookup cache?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
What is a filter transformation and why it is an active one?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
I have source like this 1:2;3. so i want to load the target as 123
What are the challenges you have faced in your project?
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What are the limitations of joiner transformation?
Why is sorter an active transformation?
Which is costliest transformation? costly means occupying more memory?