Adding DB Data Sink Merge to a project opens a configuration window and properties section. Use the configuration window and properties section to identify the connection parameters, destination table, and processing options.
To use this component
Add the component to the project and connect the ports to adjacent components.
Enter the Connection Parameters as described in the section Entering Database Connection Parameters.
Click the Destination Table button and select the table to be used from the list of available tables.
Click the Key button to open the Select Item dialog box.
Select one or more attributes composing the Key. The selected attributes are independent of any existing index definitions in the underlying database schema.
Click the Update Options button to open the Update Options dialog window. Select the attributes you want to update on existing records and enter the value you want to assign. You can specify an additional filter on the records with matching keys.
You want to mark currently valid PRODUCTS records in the destination table that match the key attribute values of the incoming records, as invalid. To set up the update options for the above case, drag the PR_DESC attribute from the left window section to the right. Specify the condition and the value to assign, if that condition turns true. You can use any comparison operator or expression allowed in the SQL language of the underlying database.
In a SQL language notation the impact of the settings will read like:
UPDATE products SET pr_desc = 'invalid' WHERE pr_desc = 'valid' AND <IN.attributes> = <PRODUCTS.attributes>
Evaluation of an expression in square brackets is taking place during initialization of the component.
