Interested to Buy Any Domain ? << Click Here >> for more details...
Discuss the advantages & Disadvantages of star & snowflake
schema?
- 5 Answers
- 46825 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
what is the -ve test case in your project.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the Default Source Option For Update Strategy Transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Do you find any difficulty while working with flat files as source and target?
Enlist the various types of transformations.
How can a transformation be made reusable?
What is pmcmd command?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Mention few advantages of router transformation over filter transformation.
How will the document be delivered to me?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How to generate sequence numbers?
What is a surrogate key?
waht type of interface is used for testing the data in informatica
