when can i use the STAR Schema and SNOWFLAKE Scgena

Question Posted / krishna.bdm9

4 Answers
9013 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / subbu

for huge amount of data snowflake schema is the best.and
for less amount of star schema is better

Is This Answer Correct ?

8 Yes

2 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / saptashaw

Star is better for performance.
Snowflake happens when one or more dimension tables in the
Star are normalized. This is done when there is sparsity in
the concerned dimensions.

Is This Answer Correct ?

3 Yes

0 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / satya/gunu(satyabadi)

=>
-Star schema is highly denormalized.
-Snowflake schema is normalized.
=>
-As star schema is denormalized, the size of DWH will be larger than that of Snowflake schema.
=>
-Performance wise, star schema is good.
-But if memory utilization is a major concern,then snow flake schema is better than star schema.
=>.. In addition, Generally in real time, we use Snowflake schema only.

Is This Answer Correct ?

1 Yes

0 No

when can i use the STAR Schema and SNOWFLAKE Scgena..

Answer / khushbu

snowflake is normalized model there for it require less storage space.
but star schema is not normalized. it has redundant data therefore require more storage.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer