Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46723 Views
- I also Faced
- E-Mail Answers
Answer Posted / ravi sadanand
Star Schema: It is fully denormalized schema.the diagram of
fact table with dimension tables resembles a star that's
why it is called star schema.All the dimensions will be in
2nd normal form.
Snow flow schema:In this all dimensions will be in
normalized form.that's why it is called normalized star
schema.For each attribut a seperate table will be
created.As there is a possibility for more number of
joins,obviously the performance will be degraded.
| Is This Answer Correct ? | 34 Yes | 11 No |
Post New Answer View All Answers
update strategy transformation in informatica
expain about the tune parameters?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are junk dimensions?
Explain what is informatica metadata and where is it stored?
what are factless facts? And in which scenario will you use such kinds of fact tables.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is informatica? Why do we need it?
How can you define user defied event?
As union transformation gives UNION ALL output, how you will get the UNION output?
Is there any target staging area in informatica not staging area
What are the settings that you use to configure the joiner transformation?
How do you migrate data from one environment to another?
Where is metadata stored?
