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
- 11590 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 is surrogate key? Where we use it? Explain with examples.
What are necessary tasks to install reportnet software?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
What is the difference between snowflake and star schema?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What are the different types of scd's used in data warehousing?
What are the different problems that ?Data mining? can solve?
Explain degenerate dimension table?
What is called dimensional modelling?
What are universe requirements?
what type of raid setup would you put your tx logs?
Explain why denormalization is promoted in universe designing?
What should I have in mind when building olap solution from scratch?
What are the key columns in Fact and dimension tables?
