The suggested table relationship results are displayed in a table. You access the table from the same application version or application module that you ran the discovery for. All of the discovery tools store the results of the discovery in the same suggestion table. The columns that are in the results depend on the discovery tool that you used to discover the table relationships. Some of the columns in the results apply to all discovery tools. If you used multiple discovery tools to discover relationships, then you can see columns that are relevant to all discovery tools.

For discovery from ERwin data models and CSV files, the results show all of the results from the exported files. Further interpretation of the results may not be necessary. You import the relationships that are already defined in the export or csv files.

For discovery from Informatica Data Quality and discovery from Informatica Developer profile results, the results are filtered based on how you generated and ran the profiles. Further interpretation of the results is necessary. View the suggested table relationships to determine the appropriate threshold to use for constraint creation. The quality of the suggested relationships depends on the quality of the data that you discovered relationships for. If you are not familiar with the quality of the data that you discovered relationships for, you may want to use a threshold of 90%. If you use a low threshold, then you may create spurious constraints. If you use a high threshold, you may ignore potential relationships.

The suggested table relationship results include the following columns:

Parent Schema

Schema of the parent table that contains primary keys. In some cases, the parent schema may not be populated. If the parent schema is not populated, then you must select a schema name when you import the suggestions.

For table relationship discovery from ERwin data models, the schema name appears if you configured the DBDNAME export parameter when you exported the data model.

Parent Table

Table that contains primary keys.

Parent Column

Column that contains the primary key.

For table relationship discovery from Informatica Data Quality and from Informatica Data Quality profile results, the primary key column that meets the primary foreign key inference criteria that you defined in the profile.

Child Schema

Schema of the child table that contains the foreign key.

Child Table

Table that contains the foreign keys.

Child Column

Column that includes the foreign key.

For table relationship discovery from Informatica Data Quality and from Informatica Data Quality profile results, the foreign key column that meets the primary foreign key inference criteria that you defined in the profile.

Overlap Percentage

Percentage of overlap between the parent and child columns.

Available for table relationship discovery from Informatica Data Quality and discovery from Informatica Data Quality profile results. Available for discovery from CSV files if the value is maintained in the CSV file.

Parent Unmatched

Percentage of values in the parent column that do not have any matches in the child column.

Available for table relationship discovery from Informatica Data Quality and discovery from Informatica Data Quality profile results. Available for discovery from CSV files if the value is maintained in the CSV file.

Child Unmatched

Percentages of values in the child column that do not have any matches in the parent column.

Available for table relationship discovery from Informatica Data Quality and discovery from Informatica Data Quality profile results. Available for discovery from CSV files if the value is maintained in the CSV file.