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
Mention a few design and development best practices for informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is domain and gateway node?
How to open an older version of an object in the workspace?
What are data-driven sessions?
What is rank transform?
explain one complex mapping with logic? sales project?
can u any challenge your project?
What is a filter transformation?
What are the components of Informatica? And what is the purpose of each?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How we can create indexes after completing the loan process?
How to load the data from people soft hrm to people soft erm using informatica?
What is pmcmd command?
What is olap (on-line analytical processing?