4.Explain Snowflkeschema ?
- 6 Answers
- 9550 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / prodyot sarkar
A snowflake schema is a variation on the star schema, in which very large dimension tables are normalized into multiple tables. Dimensions with hierarchies can be decomposed into a snowflake structure when you want to avoid joins to big dimension tables when you are using an aggregate of the fact table. For example, if you have brand information that you want to separate out from a product dimension table, you can create a brand snowflake that consists of a single row for each brand and that contains significantly fewer rows than the product dimension table.
Advantages of Using the Snowflake Schema
i)in some cases may improve performance because smaller tables are joined,
ii)is easier to maintain
iii)increases flexibility.
Disadvantages of Using the Snowflake Schema
i)increases the number of tables an end-user must work with
ii)makes the queries much more difficult to create because more tables need to be joined.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain what is the difference between view filter and report filter?
What are data modeling and data mining? Where it will be used?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is normalization, first normal form, second normal form, third normal form?
What is Star Schema?
What are templates in which way it is help full?
What is the difference between metadata and data dictionary?
How do we design a universe?
What we will do with the universe for faster process?
How can we determine what records to extract?
What is the difference between star and snowflake schemas?
What is data stream and data adaopter. Is it same are different? Explain?
How to stop a batch?
What is surrogate key? Explain with examples.
