DB Data Sink Update is a Destination component that updates or overwrites all records that match a selected key. This component does not insert new records. If there are no matching records, DB Data Sink Update does not display an error message.
Use this component to update existing records, not insert new records.
If the update values violate any restrictions of the
underlying table or object, such as, constraints, referential integrity,
unique index definition, an error message appears. The selected
Key Value attribute is independent of any existing index definitions.
