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 main use of mapplet?
What is data movement mode in Informatica and difference between them?
What is the fact table?
Explain scd type 3 through mapping.
What all are steps in up gradation of Informatica server?
How to convert multiple rows to single row (multiple columns) in informatica
what is the Default Source Option For Update Strategy Transformation?
Enlist the differences between database and data warehouse.
As union transformation gives UNION ALL output, how you will get the UNION output?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Different qualification between a related rotate toward the sky and isolates look upward?
Name the different lookup cache(s)?
Can we create multiple integration service on single repository?
What do you mean by blocking transformation?
What is the difference between informatica 7.0 and 8.0?