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
How many ways a relational source definition can be updated and what are they?
Which transformation is needed while using the Cobol sources as source definitions?
Explain the types of transformations?
What is the Process to creating lookup transformation in informatica
what is mean by complex business rule ?
What do you mean by blocking transformation?
Explain the etl program with few examples.
Explain lookup transformation in informatica
What is the commit type if you have a transaction control transformation in the mapping?
How do you use reject loader.
What is sequence generator transformation in informatica?
How might you approve all mappings in the archive all the while?
What is the status code in stored procedure transformation?
How to update or delete the rows in a target, which do not have key fields?
Explain in detail scd type 2 through mapping.
