This transformation adds a new field which contains an offset time-stamp or date value based on a provided source column.
The time offset transformation can be used to accomplish the following:
- Setting a new field for use in processing where the time of day is significant, such as HR processing or advanced workflows
- Moving existing times into a new window where times from the source system may be inappropriate
The transformation requires a date or timestamp value in the adapter schema.
This transformation adds a new timestamp field (depending on the source) with the offset time.
The time offset transformation requires the following by way of configuration.
The field containing the date or time-stamp to offset.
The field into which to put the offset calculated value.
The value to offset the source value. If the source value is a date, it is offset from midnight of the start of that day.
Use Local Time
Specifies whether an offset of a date should be offset from local time, instead of UTC time. For instance, in Brisbane, Australia, this would result in a time-stamp of of 10 hours later.
The above example generates a timestamp field AccountExpires which adds a 5pm local time offset to the date field TerminationDate, producing a field which can be used to cut off the employee's data access at the end of the work day.
During the change detection process, a change will be flagged for an entity if the Offset Field has been updated.
Customer support service by UserEcho