Drag DB Data Sink Delete component onto the Design window.
In the Database Configuration window, add the connection parameters for the target database. Specify a valid interface and host name.
See the “DB Data Sink Delete properties list” for specific field requirements.
Specify the table to which you want to write the transformation results. You can click the Destination Table icon to select the table, or manually enter the name of the table in the Destination Table field.
You can write the transformation results to an existing table or add a destination table based on existing ports in the project. For information on how to add a destination table, see “Adding a Destination table”.
To add a table based on an existing port structure, skip this step.
Click Finish.
In the Properties window, click the Key icon to select the columns identifying the records to remove from the Destination table.
You must select a Destination table before you can select a key, and you can select multiple key columns. This is a logical selection, not related to any underlying indexes in the database schema.
Specify any other optional properties in the Properties window.
Updating port structure with database changes
Loading data at IN-port to a database or a text
file
Right-click the DB Data Sink Delete component and select Flush Buffer.
The Flush Buffer option writes out the buffered rows to the target. All components for which a write block size has been specified, can buffer data until the write block size is reached. At any time during simulation, if there is data in the buffer, the Flush Buffer option will display along with the number of rows that are yet to be written to the target. If the buffer is empty, the option will be grayed out.
