Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9627 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
What are the issues you have faced in your project? How did you overcome those issues?
What is sorter transformation?
What is a stored procedure transformation?
Does an informatica transformation support only aggregate expressions?
How can you validate all mappings in the repository simultaneously?
How can informatica be used for an organization?
What will be the approach?
How do you handle two sessions in Informatica
How do we call shell scripts from informatica?
How we can create indexes after completing the load process?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is the use of target designer?
What is sq transformation?
How can we update a record in the target table without using update strategy?
What is xml source qualifier transformation in informatica?
