DataFlux Data Management Studio 2.7: User Guide

Target Settings Dialog

The Target Settings Dialog enables you to select the output type for the duplicate elimination operation and select the data removal type. The Target section of the dialog includes the following elements:

Source table - When selected, enables you to configure commit interval settings for a source table. The following settings are available:

• Commit every row from - Commit the changes as each row is written.
• Commit every # rows - Enter a value for the commit window. The changes will be committed each time this number of rows has been written.
• Commit all rows in a single transaction - Commit the changes after all rows have been written.

Flat file - When selected, enables you to appropriate flat file information. The following settings are available:

• File name - Type the name of the file that will contain the output records from the duplicate elimination operation, or click Browse to navigate to the file location.
• Delimiter - Select the field delimiter for the flat file. If you select Other, then type a single delimiter character in the text box.
• Text - Select the qualifier (a character that marks the beginning and end of the data) for text data being written to the flat file. Non-text data will not use the qualifier.
• Generate audit file only - Click to generate an audit file that shows what rows and data will be changed. This file is similar to what you would see if they viewed the results through the Merge File Viewer, but in a text file format. (This is different from the text file option that generates a flat file with the final results that can be imported into a database.)

The Data removal section of the dialog includes the following elements:

Delete Duplicate Records - Enables you to physically remove the non-surviving rows from the output, as opposed to adding a field that indicates which rows will be deleted.

Flag Duplicate Records for Deletion - Enables you to enter a delete flag field name for each primary key identified on the previous (Primary Key and Edit Fields) tab when you logically delete records. The delete flag fields can be newly created fields or fields that already exist in the source table.

Audit File Name - Enables you to enter the name of a file that will contain audit information about the duplicate elimination operation. This value is required if the target is "Generate audit file only." Otherwise, it is optional.