When you configure a data transfer task, you specify the task operation. The operations available are based on the target that you select.
You can select the following operations:
Insert
Inserts all source rows into the target. If Data Integration finds a source row that exists in the target, the row fails.
If you write data to a flat file target, Data Integration truncates the flat file before it inserts the source rows into the file.
Update
Updates rows in the target that exist in the source. If Data Integration finds a row in the source that does not exist in the target, the row fails.
Upsert
Updates all rows in the target that also exist in the source and inserts all new source rows in to the target.
If a source field contains a NULL value and the corresponding target field contains a value, Data Integration retains the existing value in the target field.
Delete
Deletes all rows from the target that exist in the source.