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
- 11582 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 Sequence clustering algorithm?
Explain what is a three tier data warehouse?
in general which algorithms for used?
How to know the time taken for particular report execution?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
How to join 3 database like flat file, oracle, db2 in informatrica?
What according to you might be the future of data warehousing?
What is a cube in data warehousing concept?
What is the data type of the surrogate key?
How to calculate fact table granularity?
What are components of reportnet?
What is real-time datawarehousing?
What are fact, dimension, and measure?
Compare and contrast aggregates & indexes
What is the difference between constraind base load ordering and target load plan?
