Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
Answer Posted / kranthi.kunta
Star flake schema will take more space than snow flake
schema.
Snow flake schema approach increases the number of joins
and results poor performance in data retrieval. In few
organizations, they try to normalize the dimension tables
to save space.
keke...
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is Cognos script editor?
Explain the definition of normalized and denormalized view and what are the differences between them?
What needs to be done while starting the database?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are the design methods of data warehousing?
What is cost benefit analysis (cba)?
What is a hash cluster?
Compare cold fusion with other programming languages?
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 are the methodologies of data warehousing?
What is Operational Data Store?
What is an er diagram?
Is there any difference in testing database and data ware housing?
Explain the structure of cold fusion?
What are the types of SCD?