Enterprise Data Manager Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

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 might 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.

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Viewing and Importing Suggested Table Relationships

Viewing and Importing Suggested Table Relationships