Configuring a DB Data Sink Delete Component

Add and configure a DB Data Sink Delete component to your project.

1. Drag the DB Data Sink Delete component onto the Design window.
2. In the Database Configuration window, add the connection parameters for the target database. Specify a valid interface and host name.
3. Specify the table to write the transformation results. You can click the Destination Table icon to select the table, or manually enter the name 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.

   To add a table based on an existing port structure, skip this step.

4. Click Finish.
5. 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.

6. Specify any other optional properties in the Properties window.

• Updating Port Structure with Database Changes
  Apply database changes to the port structure of components.
• Loading Data at Input Port to a Database or a Text File
  Use the Flush Buffer option to write 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 appears along with the number of rows that are yet to be written to the target. If the buffer is empty, the option is dimmed.