Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 9523 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / merohin27@gmail.com
star schema consists huge space then the snowflake because
star schema is de-normalised schema and snowflake is
normalised thus Star schema consists huge space
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is analytical or analytic mean?
Explain me what is vldb?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is the difference between ods and oltp?
What is the use of dimensional modeling in data warehousing?
Explain piconet?
What is the difference between Datawarehouse and OLAP?
what are the other factors of the database on which the loading performance depend?
What is a Decision Tree Algorithm?
In microstrategy, how can we direct the sql generated to use a specifc table?
What are the differences between datamart vs. Reporting cube?
Give some difference between oltp and olap.
What is is a star schema?
How to add a number to a macro variable?
