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
- 11584 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 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?
Ist the schema that a data warehouse system can implements.
Can you pass sql queries in filter transformation?
What are different deliverables according to phases?
What is critical column?
What needs to be done when the database is shutdown?
Explain piconet?
Explain what are the various file formats involved in reportnet?
Explain difference between snow flake and star schema.
Explain differences between star and snowflake schemas?
What are the various tools? Explain name a few?
Explain clustering algorithm?
What is recovering sessions?
What is pre-emptive and non-pre-emptive?
What is cfapplication tag?
