https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415032#M9266 <P><SPAN><SPAN class="ui-provider ec bjn bfq bon boo bop boq bor bos bot bou bov bow box boy boz bpa bpb bpc bpd bpe bpf bpg bph bpi bpj bpk bpl bpm bpn bpo bpp bpq bpr bps">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?</SPAN></SPAN></P> Mon, 05 Feb 2024 19:25:03 GMT lquitian 2024-02-05T19:25:03Z https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415032#M9266 <P><SPAN><SPAN class="ui-provider ec bjn bfq bon boo bop boq bor bos bot bou bov bow box boy boz bpa bpb bpc bpd bpe bpf bpg bph bpi bpj bpk bpl bpm bpn bpo bpp bpq bpr bps">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?</SPAN></SPAN></P> Mon, 05 Feb 2024 19:25:03 GMT https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415032#M9266 lquitian 2024-02-05T19:25:03Z https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415046#M9267 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/151072">@lquitian</a>&nbsp;</P> <P>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).</P> <P>Please refer to our documentation on this setting here:&nbsp;<A href="https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_applyErrorStab.htm#ar_tasks_custom_1624443382_1695278" target="_blank">Apply Conflicts #Apply Conflicts | Qlik Replicate Help</A></P> <P>If one of the replies helped to resolve the issue, please mark it as a solution &amp; like it to make it easier for others to find.<BR />Thanks in advance!</P> <P>Dana</P> Mon, 05 Feb 2024 20:32:52 GMT https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415046#M9267 Dana_Baldwin 2024-02-05T20:32:52Z https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415067#M9268 <P>Thanks for your clarification.</P> Mon, 05 Feb 2024 22:15:56 GMT https://community.qlik.com/t5/Qlik-Replicate/CDC-updates/m-p/2415067#M9268 lquitian 2024-02-05T22:15:56Z