update a record in target table without using Update strategy using Informatica

Question

How can we update a record in target table without using Update strategy?

Answer 1

At the session level we can configure any of the below option to update the records-
1. Update as Update :- Update each row flagged for update if it exists in the target table.
2. Update as Insert :- Insert each row flagged for update.
3. Update else Insert :- Update the row if it exists. Otherwise, insert it.

Answer 2

on session properties there is an option " treat source row as ", First set this as "update". After it go to the mapping tab in session and choose target table. In target table properties you will have the following options.
Insert
update as update
update as insert
update else insert
delete

If you want to apply only update operation then choose "update as update".

For Insert and update both choose" update else insert" and "insert".

For delete set "treat source row as" option as "delete" and at target level check "delete"strong textonly.