Synchronize after merge

    The Merge Rows (diff) pipeline transform appends a Flag column to each row, with a value of “identical”, “changed”, “new” or “deleted”.

    This flag column is then used by the Synchronize After Merge pipeline transform to carry out updates/inserts/deletes on a connection table.

    Advanced Tab

    OptionDescriptionDefault value from the Merge Rows (diff) transform

    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.

    Not applicable