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 is index awareness in universe?
Explain meta data?
What are modeling tools available in the market?
What is "method/1"?
Explain what are the steps to build the data warehouse?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What are session timeout and application timeout?
How to test report in reportnet?
Explain the hierarchies level data warehousing.
Explain what are the modules in power mart?
What are non-additive facts in detail?
What are the various tools? Explain name a few?
Explain what are the different methods of loading dimension tables?
What are Aggregate tables?
What are the differences between star and snowflake schema?