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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
can we override a native sql query within informatica? Where do we do it?
What are the types of lookup transformation?
What are the new features of Power Center 5.0?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What does cheating measurement mean?
What is a filter transformation and why it is an active one?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the advantages of informatica?
Explain the difference between mapping parameter and mapping variable?
What is meant by target load plan?
Enlist the various types of transformations.
Clarify the aggregator change?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.