when can i use the STAR Schema and SNOWFLAKE Scgena
- 4 Answers
- 8695 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
what is log in cognos?
When we deploy the report to live the client get the data error how can we resolve that
what is model and say about process how to create model and how to test model?
diff b/w layout calculation and query calculation
APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT
Which lifecycle we will use for reporting?
What is called Cognos powerplay?
What do you understand by the term 'aggregate cache'?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
-----------What is member Description?
drillthrough vs master detaild report,which one is the best by performance?
What do you mean by drill across?
Teradata 
