Informatica Treat Source Rows Option

In Informatica session you would have noticed an option in properties tab, Treat Source Rows as. This option effects how informatica treats rows being processed. The options available for this are 'Insert', 'Update', 'Delete', 'Data Driven'. Selecting any option effects
the way rows are processed. But for some case viz, Update and Data Driven Individual Target table option also contributes to way rows are processed. Here, we will see the effect of options being selected.

Treat Source Rows as - Insert

Individual Target option: Selecting insert option will insert rows. Disabling this option will lead to rejection of records irrespective of what other options (delete, update as update, update as insert, update else insert) are selected.

Treat Source Rows as - Delete

Individual Target option: Selecting delete option will delete the rows. Disabling this option will lead to rejection of records irrespective of what other options (insert, update as update, update as insert, update else insert) are selected.

Treat Source Rows as - Update

Individual Target option:

insert: If this is selected, Integration service uses Target update option. If disabled Integration service rejects all rows if Update as Insert or Update else Insert is selected.

update as update: Integration service updates all rows irrespective of any other target option.

update as insert: Integration service inserts all rows marked for update if the insert option is also selected else rows are rejected.

update else insert: Integration service updates existing rows and inserts new rows given the insert option is also selected.

delete: Integration service ignores this option.

Processing performed by Integration service are represented in tabular form: