Using the insert and update options of the DB Data Sink components, values are assigned to those target attributes that are not included in the inbound data stream. The values can be constants or the result of an expression. See “DB Data Sink Insert” and “DB Data Sink Update”.In the ETL demo projects and jobs, the insert options use the:
Expression – '[uDate('now','localtime')]' (today) for the Valid From date attribute.
Constant – '9999-12-31' for the Valid To date attribute.
The update options use the expression: '[uDate('now','localtime','-1 day')]' (yesterday) for the Valid To date attribute.
