Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 9896 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
Explain the main differences between star and snowflake schema?
What is is a star schema?
What is meta data and system catalog?
What is surrogate key? Where we use it?
What is the differences between star and snowflake schemas?
How to generate iqd file from framework manager?
Explain what are fact, dimension, and measure?
Explain clustering algorithm?
Explain what is full load & incremental or refresh load?
What are modeling tools available in the market?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the difference between junk dimension and degenerated dimension?
What is degenerate dimension table?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is data stream and data adaopter?
