Differentiate between Star Schema and Snowflake Schema.
|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
|One fact table surrounded by dimension table
which are in turn surrounded by dimension table
|Join||Inastar schema, only single join creates the
relationship between the fact table and any
|A snowflake schema requires many joins to fetch
|DB Design||Simple DB Design.||Very Complex DB Design.|
|Normalization||Denormalized Data structure and query alsorun faster.||Normalized Data Structure.|
|Data Redundancy||High level of Data redundancy||Very low-level data redundancy|
|Dimensions||Offers higher performing queries using StarJoin Query Optimization. Tables may be
connected with multiple dimensions.
|The Snow Flake Schema is represented by
centralized fact table which unlikely connected
with multiple dimensions.