Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Salesforce Accelerator
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Advanced Parameters

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.

0 COMMENTS

We’d like to hear from you!