DataFlux Data Management Studio 2.6: User Guide

Delete Record Node

You can add a Delete Record node to a data job to eliminate records from a data source by using the unique key of those records. Simply select the data source that contains the records you want to delete and map the primary keys from the current data input to that data source. This step works nicely with a Data Validation step placed immediately before it. You can instruct the Validation step to output only those records that fail validation, and then use the Delete Record node to delete those records from the data source.

Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the node.

Delete From Table - Specifies the records to be deleted. Click Browse to navigate to a table.

Commit Interval - Displays the Commit Interval dialog, where you can specify how often DataFlux Data Management Studio should send a commit command to the data source. The smaller the interval, the more frequent the commit, and the less likely data will not be written because of an unexpected event such as a power failure. On the other hand, the larger the interval, the faster the data will be written. The available intervals enable you to commit every row, commit at a specified interval of rows, or commit all of the rows in a single transaction.

The Primary key mappings section of the dialog includes a table that enables you to specify at least one relationship (key) between the existing table and the results of your data job. The key or keys that you select should allow the application to identify each existing record uniquely, match records to data job results, and match existing fields to result fields. In most cases, it is best to specify keys for all fields with relationships. This approach minimizes the number of fields in the resulting data set.

You can also access the following advanced properties by right-clicking the Delete Record node in the data job:

• CATALOG_NAME
• COMMIT_EVERY
• DSN
• MAX_ERROR_COUNT
• POOL_NAME
• PRIMARY_KEY
• SCHEMA_NAME
• STATUS_FIELD
• TABLE_NAME