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
Explain how to import oracle sequence into informatica?
What is a filter transformation and why it is an active one?
What is the sql query overwrite in source qualifier in informatica
can anyone suggest best free Talend data integration training online
Explain the etl program with few examples.
explan ur project architecture?
What is informatica worklet?
What differs when we choose the sorted input for aggregator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a code page?
can we override a native sql query within informatica? Where do we do it? How do we do it?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a connected transformation?
Why filter transformation is an active one?
What is the way to execute pl/sql script using informatica mapping?