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.
- Open a diagram in Diagram Visualizer, in this example Finance Dimensional DW.
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.