Tabular View
When you open the Foreign Key Profiling view, The Developer tool displays graphical view of the results by default. Switch to a tabular view to see the tables and their relationship details in a tabular format.
You can view the number of data objects in the entity, names of the related tables, their connection information, and the number of relationships between the two data objects. You can also verify the column relationships and add them to a data model.
Table Details Pane
You can view data object details in both graphical and tabular views of the enterprise discovery results. In the graphical view, the table details pane displays the number of data objects that have a direct relationship with the selected data object and the data object names.
The following table describes the columns of the table details pane in the tabular view:
Column Name | Description |
|---|
Table Name | Name of the data object that has a direct relationship with the selected data object in the left pane. |
Connection | Name of the connection for the related data object. |
Relationships | The number of relationships between the selected data object in the left pane and related data object in the table details pane. |
Verifying the Enterprise Discovery Results
When you verify the results of enterprise discovery, the Developer tool runs the profile on all rows of the data source. The conformation percentage value may vary after verification depending on the column values across all rows in the data source.
1. Open a profile after you run it.
2. Verify that you are in the Foreign Key Profiling view.
3. Click the Tabular View icon on top of the view.
The tabular view displays entities in the left pane.
4. Right-click a data object in the left pane and select View Column Relationships.
You can view the relationships of columns in the selected data object with columns in the other data objects. Scroll to the right to view details such as relationship type, conformation percentage, verification status, and commit status.
5. Right-click a row and select Verify.
The Run Profile dialog box appears. After the verification is complete, select the row to view the overlap of primary key and foreign key relationships in a Venn diagram.
Curating Column Relationships
You can approve, reject, and reset data relationships in the Foreign Key Profiling view.
1. Open a profile after you run it.
2. Verify that you are in the Foreign Key Profiling view.
3. 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.
4. In the graphical view, right-click a data object and select View Column Relationships.
5. Select a data object relationship that you want to curate.
6. To approve the column relationship, right-click and click Approve.
The status of the row changes to Approved.
7. To restore the inferred status of the column relationship, right-click and click Reset.
8. To view the rejected column relationships, right-click one of the rows, and then select Show Rejected.
9. To hide the rejected data types, right-click one of the rows and select Hide Rejected.
Committing the Results to the Model Repository
After you run a profile, you can save the column relationships between data objects to the Model repository. You can commit the relationships to the Model repository from the tabular view of the Foreign Key Profiling view.
1. Open a profile after you run it.
2. Verify that you are in the Foreign Key Profiling view.
3. Right-click a data object in the left pane and select View Column Relationships.
You can view the relationships of columns in the selected data object with columns in the other data objects.
4. Right-click a row and select Approve.