CDC updates

[lquitian]

When Replicate processes updates, does it delete the record in the destination DB and then add it back with the update or does it just process the update?

[Dana_Baldwin · Accepted solution]

Hi @lquitian 

By default, tasks will simply perform an update on the target. There is an option in Task Settings \ Error Handling \ Apply Conflicts where you can choose "INSERT the missing target record" when no record is found for applying an update. The effect of this setting is that all updates are turned into a delete + insert (we don't check to see if the row is there or not first).

Please refer to our documentation on this setting here: Apply Conflicts #Apply Conflicts | Qlik Replicate Help

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!

Dana

[lquitian]

Thanks for your clarification.