DataFlux Data Management Studio 2.6: User Guide

Primary Key/Foreign Key Analysis Dialog

You can use the Primary Key/Foreign Key Analysis dialog to configure primary and foreign key relationships for analysis in your profile. The analysis determines the number of common values in two different tables. You can perform an analysis against any data set. This feature can be most useful in maintaining referential integrity between tables in a relational database. The dialog contains the following elements:

Available - Displays the data available to the profile. You can navigate to fields that you can use for primary and foreign keys. Click Add to move one or more selected fields to the Selected field.

Selected - Displays the fields selected for primary and foreign key analysis. You can delete one or more selected fields or all of the fields.

Analyze - Initiates the key analysis process.

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

Doc ID: dfU_Profile_KeyAnalysis.html