Interested to Buy Any Domain ? << Click Here >> for more details...
difference between top down(w.h inmon)and bottom up(ralph
kimball)approach?
- 2 Answers
- 16086 Views
- PayPal, I also Faced
- E-Mail Answers
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 |
I have source like this 1:2;3. so i want to load the target as 123
What is Session and Batches?
What is confirmed dimension and fact?
What do you understand by term role-playing dimension?
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
HOW TO YOU LOAD TIME DIMENSION
how will you remove the duplicate records from flat file without using sorter?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
What is Micro Strategy? Why is it used for?
What are the differences between a connected lookup and unconnected lookup?
Which kind of index is preferred in DWH?
What is target load order?
Teradata 
