and 3 others joined a min ago.
0
499views
Differentiate between Star Schema and Snowflake Schema.
written 2.0 years ago by
pradnyanabar2613
★ 5.1k
|
modified 2.0 years ago
by
DevarenjiniP
• 3.1k
|
ADD COMMENT
EDIT
1 Answer
0
16views
|
written 2.0 years ago by
DevarenjiniP
• 3.1k
|
| 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 … |
and 4 others joined a min ago.
ADD COMMENT
EDIT
Please log in to add an answer.