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 |
How to handle changing source file counts in a mapping?
how to call lookup qualifer in unconnected look;up
plz plz plz send client names and project names in informatica?
is it possible to index the data in cache of lkp transformation ?
if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target
Can a joiner be used in a mapplet.
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
How can we get multiple output values using an unconnected lookup transformation?
What do you understand by a term domain?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
What is the function of look up transformation?