Qlik Replicate filter full load with metadata column time

[lguevara]

Hi,

I have a task in Qlik Replicate with a DB2 iSeries source and an S3 target. I would like to apply a filter on the task to perform a reload on the target. Specifically, I need to filter the transactions that occurred 3 days ago using one of the header columns (such as AR_H_STREAM_POSITION, AR_H_TIMESTAMP, AR_H_COMMIT_TIMESTAMP, or another metadata time column).

Thanks

[DesmondWOO · Accepted solution]

Hi @lguevara ,

AR_H_STREAM_POSITION, AR_H_TIMESTAMP, and AR_H_COMMIT_TIMESTAMP are metadata columns generated during CDC. Because a Reload performs a fresh query against the source table rather than reading the journals, these columns do not exist for filtering purposes during that phase.

To filter a Reload, you will need to use a physical timestamp column that exists natively in your DB2 source table.

Regards,
Desmond