TF Upsert Destination and the Upsert Method of Row Flag Compare.

is anyone using the Upsert Method of Row Flag Compare? What did you have to do to set it up to work? And what Update method were you using, Bulk, column compare, timestamp, or last Update compare?

Thanks

Luther

  • The upsert method defines how the upsert functions when executing the DML action. There are two modes:

    • The standard upsert method without a flag column - This mode inserts and updates records in the destination based on the Key(s) selected in the column mappings. If the row exists, it gets updated, if it does not exist, the row is inserted.

    official website