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.
Open an enterprise discovery profile that contains the data objects you want to analyze.
Right-click the name of a data object and select
Foreign Key Profile
.
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.
Select the keys in the parent object that the profile will use to find foreign keys in the child object.
Informatica uses cookies to enhance your user experience, improve the quality of our website, and deliver advertising and other content tailored to your interests. Some jurisdictions’ privacy laws offer their residents specific privacy rights, which we respect as described in our privacy policy. To exercise rights that you may have related to cookies, including opt-out of sharing information with third parties for advertising purposes, select "More Info" or see this "Do Not Sell or Share My Personal Information" link.