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 a rank transform?
in reporting we add some new objects,how we get the count of the newly added objects to the report
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Explain the features of connected and unconnected lookup.
What is aggregator transformation in informatica?
How to update or delete the rows in a target, which do not have key fields?
What do mean by local and global repository?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the limitations of joiner transformation?
What is a repository manager?
define galaxy repository in informatica
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Could you explain what is enterprise data warehouse?
What is a code page?
what is the Default Source Option For Update Strategy Transformation?