4.Explain Snowflkeschema ?
- 6 Answers
- 9479 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 is the difference between static cache and dynamic cache?
What is defined as partial backup?
What are the mapping paramaters and maping variables?
What are the types of SCD?
What are the data types present in bo?
What is a source qualifier?
What is is a star schema?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
How we are using this function?
Explain difference between snow flake and star schema.
Explain what is the difference between stop and abort?
How can we determine what records to extract?
What are fundamental stages of data warehousing?
What are the different types of schemas used in data warehousing?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
