how u know when to use a static cache and dynamic cache in
lookup transformation.
Answer Posted / krishna
hi neetu,
i hope you were a bit wrong.
static cache is also used to check whether row exists or
not.....
well krishna for your question on dynamic cache..
static cache is one in which data when changed in the
target table cannot be incorporated in the look up on the
fly.
when you use a dynamic cache any changes to the target
table gets reflected in the lookup even if the record is
being inserted or updated in the same mapping run priorly
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How to create Target definition for flat files?
What is the difference between informatica 7.0 and 8.0?
What is source qualifier transformation in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the function of aggregator transformation?
What is the meaning of up gradation of repository?
What is rank transform?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain about cumulative Sum or moving sum?
What differs when we choose the sorted input for aggregator transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
which one is better performance wise joiner or look up
State the differences between sql override and lookup override?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab