The Snowflake schema is an enhanced version of the Star Schema.
In this schema, dimension tables are broken down into additional sub-dimensions. For example, the Product dimension table could be further normalized into related tables, such as a SubCategory table.
Snowflake schemas offer more storage efficiency, due to adherence to normalization standards, but query performance is not as good as with more de-normalized data model like Star Schema.
Snowflake schema can be converted into Star schema by using tables merge/append options in Power Query to reduce the number of tables.
0 comments:
Post a Comment