Defining the analysis to match primary and foreign keys in tables

Procedure

In the DQ Repository tree view, expand the Data Profiling folder.
Right-click the Analyses folder and select New Analysis.

The Create New Analysis wizard opens.
In the filter field, start typing redundancy analysis and then select Redundancy Analysis, click Next.
In the Name field, enter a name for the current analysis.

Information noteImportant:
Do not use the following special characters in the item names: ~ ! ` # ^ * & \\ / ? : ; \ , . ( ) ¥ ' " « » < >

These characters are all replaced with "_" in the file system and you may end up creating duplicate items.
Set the analysis metadata (purpose, description, and author name) in the corresponding fields and click Finish.
A file for the newly created analysis is displayed under the Analysis folder in the DQ Repository tree view. The analysis editor opens with the defined analysis metadata.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!