Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 a rank transform?

1082


in reporting we add some new objects,how we get the count of the newly added objects to the report

2186


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2296


Explain the features of connected and unconnected lookup.

927


What is aggregator transformation in informatica?

935


How to update or delete the rows in a target, which do not have key fields?

1169


What do mean by local and global repository?

1218


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1072


What are the limitations of joiner transformation?

1100


What is a repository manager?

1087


define galaxy repository in informatica

2218


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1892


Could you explain what is enterprise data warehouse?

1132


What is a code page?

1168


what is the Default Source Option For Update Strategy Transformation?

1227