Code never lies, comments sometimes do [Ron Jeffries]

Visitors Map

Follow on Twitter

@ZammaCode
Powered by Blogger.

Monday, June 19, 2023

Snowflake Schema


  • 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