Interested to Buy Any Domain ? << Click Here >> for more details...
Is snow flake or star schema used?
If star schema means why?
- 4 Answers
- 9284 Views
- CTS, Sonata, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
In the aboue two (snow flake,star)schemas ,star schema is
best,because star schema is denormalised and star schema is
centrally located Fact table and surrounded by multiple
dimention tables.so fact table size can be calculated based
on the lowest level granularity of the dimentions.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / koti
star schema is for simple data marts where as snowflake
schema for complexives...
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / senthil
hi
normally people using star schema in data warehousing
because it is de_normalized and easy way to retrieve data
from target and also understanding..
But snow flake is in fully normalized.normally OLTP
we use normalized ..
star schema used in data warehousing ..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / radhakrishnansk
star schema is used for easy retrieval.
It is in 2nd normal form.
But snow flake is in 3rd normal form it needs more joins for
retrieval.
| Is This Answer Correct ? | 2 Yes | 3 No |
What are the reusable transforamtions?
Limitation of REPLACESTR. Is there any character limitation to it.
How is Data Models Used in Practice?
Enlist the tasks for which source qualifier transformation is used.
What are Dimensions and various types of Dimensions?
What is a stored procedure transformation?
Why is sorter an active transformation?
What are the different types of olap? Give an example?
What is target update override
what is the Default Source Option For Update Strategy Transformation?
How many cubes create from a single model?
explain different levels in pushdown optimization with example?
Teradata 
