DB Data Sink Synchronize updates or inserts records based on a selected key value, which can consists of one or more attributes. DB Data Sink Synchronize uses selected key attributes of the incoming records to identify and process records in the destination table:
If no matching record exists, DB Data Sink Synchronize inserts the input record.
If matching records exists, DB Data Sink Synchronize updates the records with the incoming value.
Use this component to synchronize source and destination data. You can, for example, update existing records with current source values and insert new source records into the destination table.
