Discovery Guide > Working with Models in Discovery > Working with the Relationships Tab
 
Working with the Relationships Tab
The model Relationship tab gives you details about the relationships of the resources in the model. The Relationships tab lists the relationships in tabular format and lets you:
• View details about the data source tables and their relationships.
• View details about column-to-column relationships.
• Learn about a relationship type, cardinality, status, and score.
• Filter the relationships by type or minimum score.
• Click on the column headers to change the sort column and sort order.
• Ignore columns so that they do not appear in a model. See Ignoring Certain Columns.
• Save relationship information to a Microsoft Excel file. See Saving Relationships to a File.
To work with the model Relationships tab
1. Open a model.
2. Select the Relationships tab at the bottom of the window.
Discovery displays the Relationships table
The columns in the Relationships table contain this information.
Column
Description
From Path
The full path of the “from” resource.
From Resource
The name of the “from” resource.
From Column(s)
The names of the “from” columns in the resource.
From Type
The data type for this column (VARCHAR, INTEGER, DECIMAL, DATE, etc.).
To Path
The full path of the “to” resource.
To Resource
The name of the “to” resource.
To Column(s)
The names of the “to” columns in the resource.
To Type
The data type for this column (VARCHAR, INTEGER, DECIMAL, DATE, etc.).
Type
The relationship type, which can be:
DISCOVERED
USER_DEFINED
FOREIGN_KEY
DEPENDENCY
UNKNOWN—Should not appear under normal circumstances.
Cardinality
The relationship cardinality, which can be:
ONE_TO_ONE
ONE_TO_MANY
MANY_TO_ONE
MANY_TO_MANY
UNKNOWN
Status
USER_DEFINED and FOREIGN_KEY relationships always have a status of VALID.
DISCOVERED relationships can have one of these values:
• INVALID—The user marked this relationship as invalid. It will disappear from the model diagram after marking invalid.
• VALID—The user marked this relationship as valid. Its score is set to 100.
• NOT_REVIEWED—The relationship has not been reviewed and marked as VALID or INVALID.
• UNKNOWN—Should not appear in normal circumstances.
See Editing Relationships for information about marking relationships as VALID or INVALID.
Score
The Relationship Probability Score (RPS) can be 0-100%, to indicate the likelihood that the relationship is valid. The score depends in part on the relationship type:
DISCOVERED—The relationship probability score for this relationship. See About the Relationship Probability Score (RPS).
USER_DEFINED—Always 100, because this relationship is known to exist.
FOREIGN_KEY—Always 100, because this relationship is defined in the data source.
DEPENDENCY—Always 100, because this view depends on the resource.
Hidden [check box]
Displays a check mark if this relationship is currently hidden.
Multicolumn
Displays an icon indicating that this relationship includes multiple columns. See About Multicolumn Relationships, for more information.
3. Optionally, use one of the filter buttons to determine which relationships are displayed.
4. Optionally, display details about this relationship by clicking the Show Relationship Details button. See Viewing Relationship Details, for more information.
5. Optionally: select a relationship, right-click, and choose one of these menu options.
Choose This Option
To Do This
Create View
Open a dialog that lets you specify the location in the Studio resource tree in which to save the new view.
Mark Valid
Mark this relationship as VALID.
Mark Invalid
Mark this relationship as INVALID. When displayed, relationships you have marked as invalid are shown connected by a dotted orange line in the model diagram.
Mark Hidden
Mark this relationship as hidden. The relationship continues to be listed in the Relationship table, but it is not displayed in the model diagram unless you click the Show Hidden Relationships button. Relationships marked as hidden are shown connected by a dashed line.
Edit Relationship
Open the relationship in the Edit Relationship dialog. See Editing Relationships.