AR_H_TIMESTAMP is the time associated with the change record and indicates when the change happened on the source. The AR_H_COMMIT_TIMESTAMP indicates when the change was committed on the source.
For reference, see Discussion: Difference Between AR_H_TIMESTAMP and AR_H_COMMIT_TIMESTAMP
If you would like to capture an instance when Qlik Replicate is making changes to target you can add a column via global transformation or at the table level:
- Column Datatype = DATETIME(6)
- Computation expression = datetime('now','localtime')
The expression, datetime('now','localtime') will capture the timestamp of records being inserted, deleted or updated in Replicate. We currently do not capture the time on the target system.
Environment
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.