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
- 11788 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / 9885657928
Snow flake schema
why because a denormalized dimentional table splitted into
one or more tables which results in normalization of
dimentions.It hempers the Query performance due to more
number of joins.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are cluster analysis in data warehousing?
Which columns go to the fact table and which columns go the dimension table?
Explain what are the basic needs to join two sources in a source qualifier?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
How do you define data block size?
What is a data warehousing?
I need to set predefined condition. How I do this?
What is Active Datawarehousing?
How can we load the time dimension?
What are data validation strategies for data mart validation after loading process?
explain about balanced dimension,
Explain difference between data ware house & data mart?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What are the approaches used by optimizer during execution plan?
what is an use case?
