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 are constant for all records processed during a single execution but allow for SBN expressions to dynamically initialize them. See “DB Data Sink Insert” and “DB Data Sink Update”.In the ETL demo projects and jobs, the insert options use the values:
Dynamic – '[uDate('now','localtime')]' (today) for the Valid From date attribute.
Static – '9999-12-31' for the Valid To date attribute.
The update options use the dynamic value '[uDate('now','localtime','-1 day')]' (yesterday) for the Valid To date attribute.
