Adding DB Data Sink Delete 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 DB Data Sink Delete
Add the component to the project and connect the ports to adjacent components.
Enter the Connection Parameters as described in “Entering database connection parameters”.
Create a destination table. If the destination table you are going to use already exist, continue with step 5.
Right-click the component and select either Add Destination Table from Input or Add Destination Table from Port. Optionally, the command lets you create the destination table based on the IN-port structure of the component or the structure of any other port within the project. However, you might also create the destination table with your own toolset.
Click Destination Table and select the table to be used from the list of available tables.
Select one or more attributes composing the key. This key is used to identify the records to be removed from the destination table. This is a logical selection, not related to any underlying indexes in the database schema.
