Ask
Login
0
1.8kviews
Differentiate between Star Schema and Snowflake Schema.
written 3.6 years ago by gravatar for pradnyanabar2613 pradnyanabar2613 ★ 5.2k modified 3.6 years ago by gravatar for DevarenjiniP DevarenjiniP • 3.2k
data warehouse and mining
ADD COMMENT EDIT
1 Answer
0
18views
written 3.6 years ago by gravatar for DevarenjiniP DevarenjiniP • 3.2k
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 …

Create a free account to keep reading this post.

and 2 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.