DataFlux Data Management Studio 2.5: 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:

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

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.

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_PFOutput_Target.html