Informix | Skip Deletes before 12 months

[Sreekanth_333]

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?

[john_wang · Accepted solution]

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.

[Sreekanth_333]

Thanks @john_wang !!

Will test this solution and let you know if it works

Regards

Sreekanth

[john_wang · Accepted solution]

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