Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 11790 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
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 VLDB?
Can decision tree be implemented using SQL?
How much data hold in one universe.
What is your spectra photometer working principles?
Explain what are slowly changing dimensions?
What is a hash cluster?
How to create different types of templates?
What is drilling across?
What are the types of dimensional modeling?
Explain is fact table?
What is degenerate dimension table?
Which component has onread method and what it is used for?
How to calculate fact table granularity?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How do we design a universe?
