Setting Join Status - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

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

  1. In the Navigation View, click the Discover bar, and then click the Analysis tab.
  2. Expand Joins.
  3. Expand Join Analysis Results to display a list of join jobs.
  4. Right-click a join job name and select Drill down to Joins.

    The Joins List View opens.

  5. 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.
  6. 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.