topic Qlik replicate Deletes in Qlik Replicate

Qlik replicate Deletes

rjford11 — Wed, 11 Sep 2024 17:11:31 GMT

We have Oracle 19.23 as source and target.

After large deletes on the source database we start seeing Delete statements like the following on the target:

DELETE /*+ PARALLEL("USER1"."TABLE1") */ FROM "USER1"."TABLE1"
WHERE ( "WA_POLICY_ID", "WA_TRANSACTION_SEQ", "WA_PAYMENT_SEQ" )
IN ( SELECT /*+ PARALLEL("ATTUNITY"."attrep_changes9883438C_0000157")
*/"ATTUNITY"."attrep_changes9883438C_0000157"."seg1", "ATTUNITY"."attrep_changes9883438C_0000157"."seg2",
"ATTUNITY"."attrep_changes9883438C_0000157"."seg3"
FROM "ATTUNITY"."attrep_changes9883438C_0000157"
WHERE "ATTUNITY"."attrep_changes9883438C_0000157"."seq" >= :1 and "ATTUNITY"."attrep_changes9883438C_0000157"."seq" <= :2 );

How does replicate construct this query and how are these "attrep_changes9883438C_0000157" tables created?

Re: Qlik replicate Deletes

aarun_arasu — Wed, 11 Sep 2024 17:24:06 GMT

Hello @rjford11 ,

Thanks for reaching out to Qlik community.

Please refer to the below article which explain about attrep_changes table

https://community.qlik.com/t5/Qlik-Replicate/Replicate-table-creation-quot-public-quot-quot-attrep/td-p/1786523

Regards

Arun

Re: Qlik replicate Deletes

Kent_Feng — Thu, 12 Sep 2024 00:22:26 GMT

Hi @rjford11

The Replicate Net Changes table is created on the target when working in Batch optimized
apply mode and contains records that were changed on the source.

>> How does replicate construct this query?

In batch apply mode, Replicate captures the CDC from source database and combine the events based on PK, then construct the query.

>> how are these "attrep_changes9883438C_0000157" tables created?

the Net Changes table is saved in the target database, when the source changes are applied to the target table, the net change able will be truncated.

Please check Net Changes table in the user guide for more details.

Thanks

Kent