Why should we use star schema in datawarehouse design?
- 2 Answers
- 5110 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / jz
1) Query performance is high.
2) It consume less space compare to SnowFlake.
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Is it possible to revert a global repository to local one and why?
How we can use union transformation?
Describe an informatica powercenter?
How to delete duplicate row using informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Differentiate between Load Manager and DTM?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Mention few advantages of router transformation over filter transformation.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What are some examples of informatica etl programs?
update strategy transformation in informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
