topic Informix | Skip Deletes before 12 months in Qlik Replicate

Informix | Skip Deletes before 12 months

Sreekanth_333 — Mon, 19 Aug 2024 12:19:34 GMT

Hi Team,

We are working on replication from IBM Informix to Snowflake, there is an archive job which runs everyday to delete the record older than 12 month based on the create date. We would like to skip the deletes happening for records that are 12 months older than created so that it would get deleted from target. is there any way to achieve this functionality in Qlik Replicate?

Re: Informix | Skip Deletes before 12 months

john_wang — Mon, 19 Aug 2024 14:23:36 GMT

Hello @Sreekanth_333 ,

Qlik Replicate provides rich filter functionalities, you may use filter expression like:

$AR_H_OPERATION=="DELETE" AND $CRT_DATE<date('now','-365 day')

Hope this helps.

John.

Re: Informix | Skip Deletes before 12 months

Sreekanth_333 — Tue, 20 Aug 2024 08:24:06 GMT

Thanks @john_wang !!

Will test this solution and let you know if it works

Regards

Sreekanth

Re: Informix | Skip Deletes before 12 months

john_wang — Tue, 20 Aug 2024 08:25:53 GMT

Thank you for your great support @Sreekanth_333 . Feel free to let us know if you need any additional information.