Data Synchronization Task Operations
When you configure a Data Synchronization task, you specify the task operation and the type of target. The available target types depend on the task operation that you select.
Insert Task Operation
When you run a task with the Insert task operation, Informatica Cloud inserts all source rows into the target. If Informatica Cloud finds a source row that exists in the target, the row fails. The activity log and activity monitor display the number of failed rows.
If you write data to a flat file target, Informatica Cloud truncates the flat file before it inserts the source rows into the file.
Update Task Operation
When you run a task with the Update task operation, Informatica Cloud updates rows in the target that exist in the source. If Informatica Cloud finds a row in the source that does not exist in the target, the row fails. The activity log and activity monitor display the number of failed rows.
Upsert Task Operation
When you run a task with the Upsert task operation, Informatica Cloud 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, Informatica Cloud retains the existing value in the target field.
Delete Task Operation
When you run a task with the Delete task operation, Informatica Cloud deletes all rows from the target that exist in the source.