Data Discovery Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.2
- 10.5.1
- 10.5

Back Next

Foreign Key Inference Options for Enterprise Discovery

Set up the foreign key inference options to define the column settings for discovering foreign key relationships between data objects. The foreign key inference results depend on the primary key inference options you set up for enterprise discovery, documented primary keys, and user-defined primary keys.

You can infer the foreign keys in Informatica Developer with one of the following methods:

Use default values.

Configure the foriegn key inference options.

Use foreign key configuration file to configure the auto curation parameters.

The following table describes the foreign key inference options that you configure for enterprise discovery:

Options	Description
Override the default inference options	Changes the predefined inference options.
Data types used in comparisons	The data type used in primary key and foreign key comparisons. This option applies if you run a column profile on the data source before the foreign key inference.
Comparison case-sensitivity	Includes case-sensitivity when comparing column data.
Trim values before comparison	Determines whether the Developer tool includes leading or trailing spaces in column data while processing.
Inferred primary keys used in comparisons Use top _ ranked keys	The number of top-ranking primary keys used in foreign key inference when the Developer tool runs a foreign key profile across all the data sources. The Developer tool uses the top-ranking method along with documented primary keys and user-defined primary keys to infer the foreign key relationships. Top ranking of inferred keys is based on the descending conformance percentage rounded to a single decimal precision. For example, the Developer tool considers a conformance percentage of 99.75 as 99.8 and 99.74 as 99.7. The default value is 1. Set the value to -1 if you want the Developer tool to use all inferred keys in foreign key inference. If the primary key data sources have approved primary keys, the Developer tool does not use inferred primary keys for foreign key inference.
Max foreign keys between data objects	The maximum number of inferred columns that the Developer tool returns after the profile run that are required for foreign key discovery.
Minimum conformance percentage	The minimum eligibility value in percentage for including columns in the foreign key results.
Regenerate signature	Reloads column signatures if the source data changes.

Rename Saved Search

Table of Contents

Data Discovery Guide

Data Discovery Guide

Foreign Key Inference Options for Enterprise Discovery

Foreign Key Inference Options for Enterprise Discovery