Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 9530 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / pratap gangula
In Star schema the dimensions can have attributes that may have low cardinality which when separated out in other table will decrease the storage space.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data analysis?
What is a hash cluster?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How to test report in reportnet?
How to get the first 100 rows from the flat file into the target?
I need to set predefined condition. How I do this?
Code the tables statement for a single-level (most common) frequency?
Can decision tree be implemented using SQL?
Explain where do we use semi and non additive facts?
can anybody mail me the FAQS for hyperion essbase amd planning
What is a Decision Tree Algorithm?
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.
What are situations where snowflake schema is better than star schema when the opposite is true?
What is data warehosuing hierarchy?
Explain clustering algorithm?
