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


Please Help Members By Posting Answers For Below Questions

What is native users?

931


what is INFORMATICA TESTING process

2054


Is it possible to define a single node as a Gateway node as well as worker node?

920


What is a router transformation?

837


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)

1365


What are the advantages of using informatica as an etl tool over teradata?

786


Is there any target staging area in informatica not staging area

2352


what is size of u r database?

2043


Explain the tuning lookup transformation - informatica

792


What is the use of target designer?

808


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1864


Explain the types of transformations?

803


What is meant by a domain?

858


What is the benefit of session partitioning?

830


What is the meaning of up gradation of repository?

1610