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
What is native users?
what is INFORMATICA TESTING process
Is it possible to define a single node as a Gateway node as well as worker node?
What is a router transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the advantages of using informatica as an etl tool over teradata?
Is there any target staging area in informatica not staging area
what is size of u r database?
Explain the tuning lookup transformation - informatica
What is the use of target designer?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain the types of transformations?
What is meant by a domain?
What is the benefit of session partitioning?
What is the meaning of up gradation of repository?