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


Please Help Members By Posting Answers For Below Questions

What is the difference between power center and power mart?

553


Explain how to generate iqd file from framework manager?

507


What is static and local variable?

555


How do you setup Lo-cockpit?

2630


What are Non-additive facts?

656






What is an er diagram?

634


What is Operational Data Store?

595


What is the difference between ods and oltp?

565


Explain what are components of reportnet?

551


What is a data warehousing?

607


What is recovering sessions?

538


Explain what is the difference between stop and abort?

538


what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

1813


Can decision tree be implemented using SQL?

1657


What is data stream and data adaopter?

612