(Glue-2111) Capturing of a timestamp

Change time field

There is a possibility to capture timestamps in the Glue table. For this, a Change time field is required in the 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 Glue Object Generator.

Open

Open

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.