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

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

869


What all are steps in up gradation of Informatica server?

838


What is a filter transformation?

829


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

939


Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1040


What are the steps involved in the migration from older version to newer version of Informatica Server?

1852


How can we delete duplicate rows from flat files?

998


What is a repository? And how to add it in an informatica client?

923


Describe the impact of several join conditions and join order in a joiner transformation?

857


What are different types of transformations available in informatica?

780


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2526


Explain what are the different versions of informatica?

894


Explain pmcmd command usage in informatica

920


Separate from an archive server and a powerhouse?

705


What are the mapping parameters and mapping variables?

852