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
- 11781 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / laz
The answer is STAR SCHEMA . As, the data stored in
diamensional tables of the star schema is denormalized
hence it increases the space needed for storage of data.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a source qualifier?
What is the limit to the number of sources and targets you can have in a mapping?
Explain what is cost benefit analysis (cba)?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
What is the function of etl when used in data warehousing?
What are the methodologies of data warehousing?
Explain the difference between dw and bi?
What are snapshots? What are materialized views & where do we use them?
What is a view as it relates to system modeling?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are the different ways to represent the loading of dimension tables?
Explain what is batch and describe about types of batches?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is normalization, first normal form, second normal form, third normal form?
