Running a referential integrity analysis

You run a referential integrity analysis job to evaluate whether a relationship between the foreign keys and the primary keys is valid. Foreign key values that do not match a primary key value are identified as violations.

1. Run a column analysis. See Running a column analysis job.
2. Select a primary key. You must select a primary key before attempting to run a referential integrity analysis. See Identifying a single-column primary key.
3. Run a key and cross-domain analysis.
   1. Click Key and Cross-Domain Analysis > Run a Key and Cross-Domain Analysis at the bottom of the Select Data Source to Work With window.
   2. Optional: To find foreign key candidates for the selected primary key only, click Filter Settings and check the Include only Primary Keys check box.
   3. Select tables to pair with the base table for the cross-domain analysis. Select a table to add by selecting it in the Available Tables section and clicking Add to Pair List. By default, the table that contains the primary key is specified as the base table. Columns within the paired tables will be evaluated for compatibility with the selected primary key in the base table. By default, all available pairs are automatically designated as selected pairs for evaluation.
   4. Click Next.
   5. Select scheduling options (or use the Run Now default), then click Submit and Close.
      You can use the status bar to monitor the progress of the job.
   For more details about this step, see Running a key and cross-domain analysis job to identify foreign keys
4. Run the referential integrity analysis.
   1. Click the column that was selected as the primary key (in step 2), then select Key and Cross-Domain Analysis > View Foreign Key Candidates.
   2. From the Select Base Column list, select the primary key column. This causes the columns that are paired with the selected primary key column to be displayed. If the Paired to Base percentage exceeds the Flag Percentages Above threshold, the paired column is flagged as a foreign key candidate (green flag icon).
   3. Click the flagged foreign key candidate in the Paired Columns table.
   4. Select Referential Integrity > Run Referential Integrity.
      Note: If the selected base column is not selected as the primary key column, the Run Referential Integrity menu item is disabled.
   5. Click Submit > Submit and Close.
5. To view the referential integrity analysis results, click Referential Integrity > View Referential Integrity at the bottom of the View Foreign Key Candidates window.