Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Data Discovery
  3. Part 2: Data Discovery with Informatica Analyst
  4. Part 3: Data Discovery with Informatica Developer
  5. Appendix A: Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Discovering Foreign Key Relationships Between Data Objects

Discovering Foreign Key Relationships Between Data Objects

Use an enterprise discovery profile in the Developer tool to find key relationships between two data objects
The data object that contains the primary key is the parent object, and the data object that contains the foreign key is the child object.
  1. Open an enterprise discovery profile that contains the data objects you want to analyze.
  2. Right-click the name of a data object and select
    Foreign Key Profile
    .
  3. Enter a name for the profile and verify the project location. If required, browse to a new location. Optionally, enter a text description of the profile.
  4. Select the keys in the parent object that the profile will use to find foreign keys in the child object.
  5. Save and run the profile.

0 COMMENTS

We’d like to hear from you!