Viewing and Importing Suggested Table Relationships
Viewing and Importing Suggested Table Relationships
After you discover table relationships, view the suggested relationships. Choose the relationships that you want to import as constraints. When you import the suggested relationships as constraints, the ILM engine creates the constraints for the related table metadata in the ILM repository.
Click
File
View Constraints
to open the Constraints tab.
In the navigation pane, right-click the application version or application module that you want to import relationships for. Select the same application version or application module that you used when you discovered relationships.
Select
View Suggested Table Relationships
.
A table appears with the suggestions from the table relationship discovery process.
Review the suggestions.
If you discovered relationships from ERwin data models or from profile results that were generated from Informatica Developer, you may need to select the parent and child schema names from the drop-down box.
If the discovery tool cannot identify the parent and child schema names, then the schema name is populated with an underscore.
Select the suggestions that you want to import and click
Submit
.
The ILM engine creates constraints for the related tables in the ILM repository.