Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
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
Explain what are the different methods of loading dimension tables?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
Explain where do we use semi and non additive facts?
What is data analytics in simple terms?
I need a good brd and uc template?
Explain bus schema?
Explain some of modeling tools available in the market?
Who needs data warehousing?
What is operational data store (ods)?
What is the difference between connected and unconnected stored procedures?
What should I have in mind when building olap solution from scratch?
Explain conformed fact?
Explain what is batch and describe about types of batches?
How many project sources we can create in metadata?
What are the advantages and disadvantages of reporting directly against the database?