Answer Posted / tamilarasan m
Star fact table join with all the dimension tables.All the
dimension tables are denormalized.ain Snowflake dim table
join with another dimension.All the dimension r normalized
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is depict expression change?
What you know about transaction control transformation?
What is informatica? Why do we need it?
What are the issues you have faced in your project? How did you overcome those issues?
Explain what transformation and how many are there in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How you can differentiate between connected lookup and unconnected lookup?
Explain the code page compatibility?
What do you mean by channel change?
What can we do to improve the performance of informatica aggregator transformation?
What is meant by target load plan?
my source is junk data how will u remove that junk data by using unix please any one replay me
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How do you load first and last records into target table?
How to update a particular record in target with out running whole workflow?