Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 9486 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / prasant tripathy
Hi
star schema takes more space then the snowflake because
star schema is denormalised schema and snowflake is
normalised
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Explain clustering algorithm?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is metadata in context of a datawarehouse?
Do you view contain data?
What is the difference between datawarehouse and bi?
Briefly state different between data ware house & data mart?
Describe the differences between a data warehouse and data mart.
Explain what are the various transformation available?
Explain what is power center repository?
What is surrogate key? Where we use it? Explain with examples.
What are the various methods of getting incremental records or delta records from the source systems?
Explain the difference between view and materialized view?
What is difference between e-r modeling and dimensional modeling?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain when do we analyze the tables? How do we do it?
