4. best practices say we should try to handle GM by creating a Degenerate Dimension
Answer : The correct statement about Granularity Mismatch is 1 : GM is caused by snow flaking(normalizing the dimension tables).
Snowflaking" is a method of normalizing the dimension tables in a star schema. When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle. The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
The primary disadvantage of the snowflake schema is that the additional levels of attribute normalization adds complexity to source query joins.
Get Answers For Free
Most questions answered within 1 hours.