(Glue-2211) Capturing of a timestamp

Owned by SNP
Nov 09, 2022
1 min read

Change time field

There is a possibility to capture timestamps in the SNP Glue™ table. For this, a Change time field is required in the SNP Glue™ table. This field can have a custom name but data element /DVD/GL_CHANGE_TIME is mandatory for the field to be recognized as a Change time field. This field can be added in GL11 and also automatically generated via SNP Glue™Object Generator.

Usability

Change time field is used to capture the time stamp of an extraction. In the case of the standard full load timestamp of extraction is captured. If a trigger is used and the load type is different from the full load, the timestamp is taken from the shadow table. In this case, change time is the same as the time of a captured operation in the shadow table.