MSBI -- SSAS -- Part-5
Star-Schema and Snow Flake Schema
Schema:
Logical
representation of database Object is called schema.
1. Star
Schema:
In a Dimensional Modelling Schema,
if all the dimension tables are directly connected to the centralized Fact Table and no Dimension Tables are further normalized such a type of
schema is known star schema.
2.
Snowflake
Schema:
In
a Dimensional Modelling Schema, any one or more Dimension Tables are further
normalized and normalized child dimension will not directly connected to Fact Table and it is connected to its Parent Dimension Table, Such a type of Schema
is known as Snow flake Schema.
Logical
representation of database Object is called schema.
1. Star
Schema:
In a Dimensional Modelling Schema,
if all the dimension tables are directly connected to the centralized Fact Table and no Dimension Tables are further normalized such a type of
schema is known star schema.
No comments:
Post a Comment