Operation fieldname

This is a required field. This field is used by the transform to obtain an operation flag for the current row.

“flagfield”

Specify the value of the Operation fieldname which signifies that an Insert should be carried out.

“new”

Update when value equal

Specify the value of the Operation fieldname which signifies that an Update should be carried out.

“changed”

Delete when value equal

Specify the value of the Operation fieldname which signifies that a Delete should be carried out.

“deleted”

Perform lookup

Performs a lookup when deleting or updating. If the lookup field is not found, then an exception is thrown. This option can be used as an extra check if you wish to check updates/deletes prior to their execution.