User`s guide

CHAPTER 6 Components
User’s Guide 115
DB Data Sink Delete component
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.
❖ To use DB Datasink Delete
1 Add the component to the project and connect the ports to adjacent
components.
2 Enter the Connection Parameters as described in “Entering database
connection parameters” on page 71.
3 Create a destination table. If the destination table you are going to use
already exist, continue with step 5.
4 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.
5 Click Destination Table and select the table to be used from the list of
available tables.
6 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.
Optional properties
Write Block Size
The Write Block Size defines the number of records to be written to the
database in a single write operation.
Pre-processing SQL
This property provides one or more SQL statements to be executed during
initialization of the project.