Getting More Information about Relationships
Studio includes two system tables specific to Discovery. These tables provide more details about the discovered relationships in all resources that have been indexed and discovered, and for which the current user has privileges:
• ALL_RELATIONSHIP_COLUMNS—Lists every relationship, its ID, its “from” column/table/schema/catalog/data source and their IDs, and the same information for the “to” column.
• ALL_RELATIONSHIPS—Lists every relationship, its type, cardinality, status, column information, and score information including the actual factors discovered, such as number of matches.
A summary of this information specific to each model can be viewed on the model’s
Relationships tab. (See
Working with the Relationships Tab, for more information.) However, the specific factor information discovered for each relationship is available only in the
ALL_RELATIONSHIPS table
.Note: For a complete description of these two tables, see the TDV Reference Guide.
To view the Discovery system tables
1. In the Studio resource tree, expand the Data Services branch display the system tables: Data Services > Databases > system.
2. Select ALL_RELATIONSHIPS.
3. Right click and select Open from the pop-up menu.
Discovery opens the table, displaying its columns and column types.
4. Click Show Contents to display the actual relationships table in the lower pane.
5. To see all details about the relationships, scroll to the right.