Answer Posted / kamesh
When ever a mapping contains Update Strategy Transformation
the way data needs to be treated is declared in the session
property as Data Driven. This is done by mentioning
DD_UPDATE or DD_INSERT or DD_DELETE in the update strategy
transformation.
A mapping may contain two Update strategy transformations,
1 for inserting and another for updating in two different
pipelines in single mapping.
Therefore, in order session to get executed successfully,
mention Data Driven property in the session properties for
that particular mapping.
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What is a standalone command task?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Explain the shared cache and re-cache?
Where can we find the throughput option in informatica?
What is the Rank index port in Rank transformation?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Difference between Data and Index Caches?
Mention few power centre client applications with their basic purpose?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the features of complex mapping?
What is parallel processing in informatica?
What is the session task and command task?
define galaxy repository in informatica
what is SDLC way of code development?