Populating the Target Dimension Table

Learn how to assign values to target attributes and perform partial updates.

Assigning Values to Target Attributes

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. 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.

Performing Partial Updates

The update options of a DB Data Sink component allow a subset of attributes to be updated, instead of updating the complete record. To exclude attributes from update, unselect them in the update options window. In the ETL demo projects, old records are outdated by updating the Valid To date attribute.

Related concepts
DB Data Sink Update
DB Data Sink Insert