topic Re: Restrict delete not to replciate in Qlik Replicate

Restrict delete not to replciate

gulshanr — Tue, 23 Aug 2022 13:01:17 GMT

Hello All,

We are replcating data from source (DB2) to Destination (Netezza). My customer want all data to be replciated but any delete on source should NOT be deleted on destination DB.

Any idea, how can we achieve this? Cab Qlik replicate fulfil such ask or I need to build custom solution outside Qlik?

Thanks,

Re: Restrict delete not to replciate

Arun_Arasu — Tue, 23 Aug 2022 13:33:18 GMT

Hello @gulshanr

I would recommend to try expression builder to exclude the records for which AR_H_OPERATION = delete.
Please go thru the below user guide for more information

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_headColumns.htm
https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_buildExpress.htm

Regards,
Arun