Is snow flake or star schema used?
If star schema means why?
Answer Posted / 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 |
Post New Answer View All Answers
write a query to retrieve the latest records from the table sorted by version(scd)
What are active and passive transformations?
can we override a native sql query within informatica? Where do we do it?
What is the difference between Active and Passive transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How can we use mapping variables in informatica? Where do we use them?
What does role playing dimension mean?
What all join we can perform in LOOKUP transformation?
Separate from an archive server and a powerhouse?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How is union transformation utilized?
What is the surrogate key?
When do you use sql override in a lookup transformation?
What are the types of caches in lookup? Explain them.