Is snow flake or star schema used?
If star schema means why?
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 is aggregator transformation in informatica?
what is normalizer transformation?
can anyone suggest best free Talend data integration training online
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What is version control in informatica ? Advance thanks
Can we have a Mapping without a Source Qualifier?
How do you manage the Parameter files while migrating your data from one environment to another environment?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Why we use ENABLE HIGH PRECISION in session properties?
How you load distinct records into one target and duplicate records into another target?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?