DataFlux Data Management Studio 2.5: User Guide

Data Target (Update) Node

You can add a Data Target (Update) node to a data job to output data in a variety of data formats. Unlike the Data Target (Insert) node, which you can use to create a new data source, the Data Target (Update) node is designed for updating existing data. For example, if your existing data has questionable ZIP codes, you might update a data target in conjunction with Geocoding to write verified ZIP codes over the questionable codes without changing any other fields.

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.

Output table - Enables you to enter the path and name of your output file. You can also click Browse to navigate to the output file location.

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 following commit intervals are available:

• Commit every row
• Commit every [x] rows
• Commit all 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.

The Output fields section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

Override - Displays the Override Defaults dialog. You can use the dialog to override the default field lengths.

You can access the following advanced properties by right-clicking the Data Target (Update) node:

• BIND_USING_TABLE_TYPE
• CATALOG_NAME
• COMMIT_EVERY
• DSN
• ENABLE_DDL
• FIELDS
• MAX_ERROR_COUNT
• POOL_NAME
• PRIMARY_KEY
• SCHEMA_NAME
• STATUS_FIELD
• TABLE_NAME