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
- 15820 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 |
what is the difference between copy object import objects using repositery manager which one is best
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
Differentiate between sessions and batches?
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is the significance of newlookup port in dynamic look up
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
What is the Rankindex in Ranktransformation?
When do you use sql override in a lookup transformation?
How would you join a node to the already existing domain?
wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35
Teradata 
