Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9292 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to Create a folder using pmrep command?
Slowly changing dimensions, types and where will you use them
How to load the data from people soft hrm to people soft erm using informatica?
In informatics server which files are created during the session rums?
what is the complex transformation you used in informatica
What is the format of informatica objects in a repository?
What is an aggregator transformation?
Explain the tuning lookup transformation - informatica
What is a joiner transformation?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a connected transformation?
If informatica has its scheduler why using third party scheduler?
What all are steps in up gradation of Informatica server?
What are the main issues while working with flat files as source and as targets ?
How would you join a node to the already existing domain?
