Difference between Star-Schema and Snowflake Schema

Star-Schema:
  1. A Centralized fact table surrounded by n number of dimensions is known as fact table.
Star-Schema contains one fact table and one or more dimension tables.
  1. Its Normalized model.
  2. Easy to use and understand, because of fewer joins contains.
  3. More time for execution, because of more joins.
Snowflake Schema:
1) Any dimension with extended dimensions are known as snowflake schema.
2) Its De-Normalized model.
3) End users will get confused, because of complicated joins.

4) Execution is less, because of more joins. 

Leave a Reply

Your email address will not be published. Required fields are marked *