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 |
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
In development project what is the process to follow for an etl developer from day1
How to run a session, which contains mapplet?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Is it possible to update the target table with PK?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the disadvantages of Sequence Generator T/R?
What is rank index in rank transformation?
Explian the Process of deployment groups in informatica
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
how i will stop my workflow after 10 errors