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.