Update Strategy Transformation in Informatica

Update Strategy transformation is an active transformation that flags a row for insert, update, delete, or reject. The Update Strategy transformation tests each row to see if it meets a particular condition, and then flags the row accordingly.  You can configure the transformation to pass rows flagged for reject to the next transformation or to drop rows flagged for reject.

Lists of constants for each database operation and their numeric equivalent

You can disallow inserts or deletes for rows flagged for insert or delete. You can choose different ways to handle updates for all rows flagged for update. Define the update strategy options in the Advanced properties of a target data object in a mapping. You can set the following update strategy options
Insert Inserts all rows flagged for insert into a target. 

Delete Deletes all rows flagged for delete from a target.

Update Strategy Update strategy for existing rows. Select one of the following strategies:

Update as Update Updates all rows flagged for update. This is the default value.

Update as Insert Inserts all rows flagged for update.

Update else Insert Updates all rows flagged for update if they exist in the target and then inserts any remaining rows marked for insert.

Truncate Table Truncates the target before loading data.

Advanced Properties for Update Strategy Transformation

Forward Rejected Rows Determines whether the Update Strategy transformation passes rejected rows to the next transformation or drops rejected rows. The Data Integration Service flags the rows for reject and writes them to the reject file. If you do not select Forward Rejected Rows, the Data Integration Service drops rejected rows and writes them to the mapping log file.

Tracing Level Amount of detail that appears in the log for this transformation.

Scenario

Load the target table with employee data with salaries higher than 2000 otherwise reject them. 

*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.