This component removes records from the destination table that match the incoming values of a selected key. There will be no error message if no matching record exists.
Use the component to clean your table from records no longer required.
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.
To use DB Datasink Delete