0
618views
Differentiate between Star Schema and Snowflake Schema.
1 Answer
written 2.5 years ago by |
Parameter | Star Schema | Snow Flake Schema |
---|---|---|
Hierarchies | Hierarchies for the dimensions are stored in the dimensional table. |
Hierarchies are divided into separate tables. |
Structure | It contains a fact table surrounded by dimension tables. |
One fact table surrounded by dimension table which are in turn surrounded by dimension table |
Join | Inastar … |