You can approve, reject, and reset data relationships in the
Foreign Key Profiling
view.
Open a profile after you run it.
Verify that you are in the
Foreign Key Profiling
view.
In the graphical view to reject an inferred column relationship, select the data object, right-click a data object, and select one of the following options:
Reject All Relationships with
Inferred Primary Keys
. Choose this option to reject all the relationships between the columns with inferred primary keys in the data object to the columns with inferred foreign keys in the other connected data objects.
Reject All Relationships with
Inferred Foreign Keys
. Choose this option to reject all the relationships between the columns with inferred foreign keys in the data object to the columns with inferred primary keys in the other connected data objects.
Reject All Relationships with
Inferred Primary and Foreign Keys
. Choose this option to reject all the relationships between the columns with inferred primary keys in the data object to the columns with inferred foreign keys in the other connected data objects, and all the relationships between the columns with inferred foreign keys in the data object to the columns with inferred primary keys in the other connected data objects.
In the graphical view, right-click a data object and select
View Column Relationships
.
Select a data object relationship that you want to curate.
To approve the column relationship, right-click and click
Approve
.
The status of the row changes to
Approved
.
To restore the inferred status of the column relationship, right-click and click
Reset
.
To view the rejected column relationships, right-click one of the rows, and then select
Show Rejected
.
To hide the rejected data types, right-click one of the rows and select