Relationship views are available for technical assets in the catalog source. You can connect assets to each other using different types of relationships.
A relationship between assets shows how the assets relate to one another. When data from a source system is ingested into the catalog, Data Governance and Catalog can automatically create relationships among the technical assets of that source system.
For more information about viewing relationships, see Relationships in the Data Governance and Catalog help.
View relationships at catalog source level
The Relationships tab of an asset page displays the relationships between the selected asset and other business and technical assets in Data Governance and Catalog.
The erwin Data Modeler File catalog source reads metadata from the input data model and creates reference assets in the model. You can view the relationship with reference objects without performing connection assignment. After connection assignment, you can view the relationship between the actual objects extracted by the erwin Data Modeler File catalog source.
To view relationships at the catalog source level, search for and open an erwin Data Modeler File catalog source, click the Relationships tab and expand the catalog source.
The following image shows the relationship between the erwinFile_Erwin_134 catalog source and the erwin Data Modeler File reference catalog source:
View relationships at data set level and data element level
The relationships at the data set level and the data element level show how technical assets such as tables and columns are related to the selected asset.
Data sets are technical assets that contain sets of data. For example, a table in a source object. Data elements are objects upstream or downstream of a data set. For example, a column in a source object.
View relationships at the data set level
The relationships at the data set level show how the technical assets such as tables are related to the selected asset. To view relationships at the data set level, open a technical asset such as a table, click the Relationships tab, and then expand the data set.
The following image shows the table-to-table relationship between the erwin Data Modeler File Department asset and the referenced Department data set before the connection assignment:
The following image shows the table-to-table relationship between the erwin Data Modeler File Department asset and the Oracle table after connection assignment:
View relationships at the data element level
The data element level displays details of the data set level. The relationships at the data element level show how the technical assets such as columns are related to the selected asset. To view relationships at the data element level, open a technical asset, click the Relationships tab, and then expand the data element.
The following image shows a table to column relationship between the erwin Data Modeler File Dept_name asset and the referenced Dept_name data element before connection assignment:
The following image shows a table to column relationship between the erwin Data Modeler File Dept_name asset and the DEPT_NAME column after connection assignment:
