Tasks

Back Next

Task operations

When you configure a

synchronization

task, you specify the task operation and the type of target. The available target types depend on the task operation that you select.

You can use one of the following task operations:

Insert: When you run a task with the Insert task operation,
Data Integration
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: When you run a task with the Update task operation,
Data Integration
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: When you run a task with the Upsert task operation,
Data Integration
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: When you run a task with the Delete task operation,
Data Integration
deletes all rows from the target that exist in the source.