When we configure an Informatica Power Center session, we have several options for handling database operations such as insert, update, and delete, by using these properties we can update records without using any transformations.
I just created one sample mapping, without using any transformations
We have source and target with same data
I just update few records at source level
UPDATE Categories SET CategoryName=’Cooldrinks’ WHERE CategoryID IN (3,6);
Implementation of session properties:
Let’s set up the session properties such that the session will have the capability of both insert and update.
We have options like
- Insert: – Treat all rows as inserts.
- Delete: – Treat all rows as deleted.
- Update: – Treat all rows as updates.
- Data Driven :- Integration Service follows instructions coded into Update Strategy flag rows for insert, delete, update, or reject
We need to set up target level properties like the below figure, Save the changes and rerun the task