Regarding delay in record retrieval from __ct table
hi Team,
We were doing an exercise to pull the records from __ct table( in target Postgres db) and pushing some change in the source system database (SQL Server) as some delay was reported by client team.
We observed that there is around 3~4 secs of the delay ( current timestamp in DB when the record first appears in __ct table) versus the header__timestamp/ $AR_H_TIMESTAMP values that are captured in __ct table.
Can you pls explain why do we see this delay , in spite of the $AR_H_TIMESTAMP value is captured earlier?
Pls see the screen capture for the resultset we got.
P.S. -we are capturing $AR_H_TIMESTAMP value in processed_timestamp column .
For more details and the usage of the $AR_H_TIMESTAMP and values please refer to the Qlik Replicate User Guide as shown in the 2021.11 Release User Guide link:
For more details and the usage of the $AR_H_TIMESTAMP and values please refer to the Qlik Replicate User Guide as shown in the 2021.11 Release User Guide link:
