Identifying relationships between associated tables in a diagram - 7.1

Talend Data Catalog Manager User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend Data Catalog

You can identify the primary keys and foreign keys in the associated tables in a diagram.

A primary key (PK) is an attribute that uniquely identifies an instance of the entity.

A foreign key (FK) is used to link two tables together.

Procedure

  1. Open a diagram in Diagram Visualizer, in this example Finance Dimensional DW.
  2. Click a relationship between two tables.
    The associated primary key and foreign key are highlighted.

    In this example, you want to identify the PK/FK pair corresponding to the associated Customer PO Invoice Item and Customer Payment Date tables.

    Customer Payment Date is the primary key and Customer Payment Date Dimension ID (FK) is the foreign key.