DB Data Sink Merge uses key attribute values to update and insert records in a destination table according to user defined rules.
Use this component for dimension tables that store current and historical data. You can, for example, use DB Data Sink Merge to insert a new instance of a particular record type.
