Enterprise Data Manager Guide

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

Back Next

Advanced Parameters

Provide the advanced parameters when you discover relationships from Data Quality. The parameters determine how Data Quality generates and runs the profile. The parameters to generate profiles from the Enterprise Data Manager are the same as if you generate the profiles from Informatica Developer. For more information about the parameters, see the Informatica Data Quality Profile Guide
.

Primary Key

Configure the following advanced parameters for primary key discovery:

Maximum Key Columns: Maximum number of columns that can make up a primary key.
Maximum Rows: Maximum number of rows to profile for primary key discovery.
Conformance Criteria: Minimum percentage or maximum number of rows of key violations that the profile allows for primary key discovery.
Choose one of the following conformance criteria:
Minimum Percentage. Minimum percentage of key violations that the profile allows for primary key discovery. For example, if you enter 90, the profile returns primary keys that have more than 90% accuracy.
Maximum Violation Rows. Maximum number of rows of key violations that the profile allows for primary key discovery.

Foreign Key

Configure the following advanced parameters for foreign key discovery:

Datatypes used in Comparison: Determines if the profile uses data dictionary datatypes instead of generic datatypes.
Choose one of the following options:
Inferred Datatypes. The profile uses generic datatypes.
Metadata. The profile uses data dictionary datatypes.
Comparison Case Sensitivity: Determines if comparison includes case sensitive differences.
Choose one of the following options:
Case Sensitive. Determines if the profile runs case sensitive comparisons. If you select this option, the profile job performance may be impacted.
Not Case Sensitive. Does not display case sensitive differences.
Trim Spaces before Comparison: Determines if Informatica Developer includes leading or trailing spaces in column data.
Maximum Foreign Keys Returned: The maximum number of inferred columns that Informatica Developer returns.
Minimum Confidence Percent: Minimum percentage of key violations that the profile allows for foreign key discovery. For example, if you enter 90, the profile returns foreign keys that have more than 90% accuracy.
Regenerate Signature: When checked, reloads column signatures if the source data changes.

Rename Saved Search

Table of Contents

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Advanced Parameters

Advanced Parameters

Primary Key

Foreign Key