Qlik replicate Deletes

[rjford11]

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?

[aarun_arasu]

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/t...

Regards

Arun

[Kent_Feng]

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