Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
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 are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
How to pivot data using informatica when you have variable amount of pivot rows?
What is the difference between metadata and data dictionary?
explain about dirty dimension?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
How we are using this function?
What is data analysis?
What is the difference between data warehouse and operational systems?
what are the major three types of modeling used?
Explain the main differences between star and snowflake schema?
Who needs data warehousing?
Where the cache files stored?
What is MODEL is Data mining world?
What are the data marts?
How to limit the max no of rows retrieved in the report?