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
- 11327 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 a junk dimension? What is the difference between junk dimension and degenerated dimension?
What are the advantages and disadvantages of reporting directly against the database?
What is Discover and Execute in XMLA?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What are the data marts?
What are the advantages of cold fusion?
How do you define data block size?
Explain what is the difference between a primary and secondary actor in use case modeling?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
Explain what are necessary tasks to install reportnet software?
What is meant by metadata in context of a data warehouse?
What are the difference between snow flake and star schema?
What are the different types of data warehouses?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is dimensional modelling?
