Snow Flake Schema
·
In snow Flake schema also same
as star schema like all dimension tables related with Fact table and some of
the Dimension table linked with Dimension tables only.
·
One or more dimension tables
are partially or completely normalized in Snowflake schema.
·
Snowflake schemas normalize
dimensions to eliminate redundancy. That is, the dimension data has been
grouped into multiple tables instead of one large table.
·
The main Principle of snowflake
is normalization of the dimension tables by removing redundancy of attributes
and creating separate tables.
The
above diagram explains that the dimension tables of Customer, Time, Product and
Geography are connected to Fact table of FactInternetSales , Product Dimension
table related with another dimension table ProductSubcategory.
No comments:
Post a Comment