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
- 15962 Views
- PayPal, I also Faced
- E-Mail Answers
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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
expain about the tune parameters?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
list out all the transformations which use cache?
What is a difference between complete, stop and abort?
Why do you use Mapping Parameter and mapping variable?
Can we override a native sql query within informatica?
What is deployment group?
What are the different transaction levels available in transaction control transformation?
tell me the rules and responsblites in our project(my project is development)
What are the informatica performance improvement tips
How does the aggregator transformation handle null values?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Can we create two repositories on same database instance in oracle?
How do you change a non-reusable transformation to reusable transformation?
