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
Repository user profiles
Mention few advantages of router transformation over filter transformation.
Is there any way to read the ms excel datas directly into informatica?
What are the informatica performance improvement tips
How to use procedural logic inside infromatica?
how to load dimension table and fact table. plz tell me the steps.
What you know about transaction control transformation?
What is source qualifier transformation in informatica?
How to handle decimal places while importing a flatfile into informatica?
When do you use sql override in a lookup transformation?
What are pre and post-session shell commands?
Enlist the tasks for which source qualifier transformation is used.
generate date / time dimension in informatica
What is target load order?
What are the components of workflow manager?