Tasks

Back Next

Task operations

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.