Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 9895 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 Non-additive facts?
How to improve session performance in aggregator transformation?
How to pivot row data using informatica?
How to performance tune reports?
How can we run the graph?
What is ods (operation data source)?
What are target types on the server?
What are vaious etl tools in the market?
What is a staging area? Do we need it? What is the purpose of a staging area?
Whether dimension table can have numeric value?
What is the purpose of cluster analysis in data warehousing?
What is real-time datawarehousing?
Explain what are the methodologies of data warehousing?
Store (and count) non-fact records?
What are templates in which way it is help full?
