After joins are discovered or created, review join analysis results and make decisions about whether to change the status of a join, depending on the current state of the join and your analysis needs. For example, you can set to permanent a discovered join that you want to keep for further relationship analysis.
To review join analysis results and set join status
- In the Navigation View, click the Discover bar, and then click the Analysis tab.
- Expand Joins.
- Expand Join Analysis Results to display a list of join jobs.
-
Right-click a join job name and select Drill down to Joins.
The Joins List View opens.
- Review each join in the List View. As a best practice, find the highest Match Best percentage of the displayed joins as a place to start reviewing. The Match Best is a percentage that measures the best match of the join's Value, RHrow, and LHrow.
-
Right-click one or more joins and use the information in the following table to help you decide which action to take:
If...
Action
Join is expected.
Set permanent
Join is on an attribute that could act as an alternative unique identifier and might be a useful join when there are issues with keys, or you have cross application joins to do.
Set permanent
Permanent joins are displayed in Entity Relationship Diagrams. You can change the join status to discovered to exclude the join from ERDs.
Set discovered
Join is on an entity or attribute where a join should never occur such as on a date or time and there is no business value in having such a join. Change properties on those entities or attributes to exclude joins from future discover join analysis, as follows:
- If applied at the entity level, then no joins will be discovered that include that entity. (For the procedure, see Modifying Attribute Properties.)
- If applied at the attribute level, then no joins will be discovered that include that attribute. (For the procedure, see Editing an Entity.)
Exclude entity or attribute from future join analysis
Note: As you delete or mark joins as permanent, the Joins Reviewed % increases.