Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11171 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
What are various warehousing tools?
What is data stream and data adaopter?
Explain multivalued dependency?
Store (and count) non-fact records?
Explain what are components of report studio?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is difference between model & package?
What is a fact, dimension, measure?
Database in use is oracle?
What is the purpose of cluster analysis in data warehousing?
What is factless fact tables?
What is metadata in context of a datawarehouse?
What are the different types of datawarehosuing?
What are Aggregate tables?
Explain what is the difference between a primary and secondary actor in use case modeling?
