Data Discovery Guide

Back Next

Defining Parent and Child Object Relationships

To find foreign key relationships between two data objects, you must select a parent data object and specify the primary key in that object.

Open an enterprise discovery profile that contains the data objects you want to analyze.

Select the parent object.

Select the primary key in the parent object:

Click the

Properties

tab, and click

Keys.

Click

Add

, and select the primary key column in the New Key dialog box.

Click

in the

New Key

dialog box. Verify that the primary key is displayed in the

Selected fields

pane and that the

Primary Key

option is checked.

Create a foreign key profile to analyze the child object for foreign keys.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.