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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What all are steps in up gradation of Informatica server?
What is a filter transformation?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
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.
What are the steps involved in the migration from older version to newer version of Informatica Server?
How can we delete duplicate rows from flat files?
What is a repository? And how to add it in an informatica client?
Describe the impact of several join conditions and join order in a joiner transformation?
What are different types of transformations available in informatica?
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
Explain what are the different versions of informatica?
Explain pmcmd command usage in informatica
Separate from an archive server and a powerhouse?
What are the mapping parameters and mapping variables?