difference between top down(w.h inmon)and bottom up(ralph
kimball)approach?
Answer Posted / 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 |
Post New Answer View All Answers
r u done any partitions in ur project?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What do you understand by term role-playing dimension?
What is update strategy transform?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the use of target designer?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain about Informatica server process that how it works relates to mapping variables?
write a query to retrieve the latest records from the table sorted by version(scd)
How to join three sources using joiner? Explain though mapping flow.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
how to load rows into fact table in data warehouse
Which development components of informatica have the highest usage?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?