Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

Entity Profile Options

Entity Profile Options

TDM infers foreign key candidates from the source tables. To limit the candidate results, specify inference options.
Define options to configure how the entity profile matches the datatypes of the primary keys and the foreign keys of the entity table.
The following table describes the entity profile options:
Option
Description
Datatypes used in comparisons
The datatype to use for comparisons.
Select one of the following options:
  • Inferred Datatypes. Compares the primary key and the foreign key based on the datatypes inferred by TDM.
  • Documented Datatypes. Compares the primary key and the foreign key based on the datatypes defined for the source column.
Comparison case sensitivity
Performs case-sensitive comparisons.
Trim spaces before comparison
Trims spaces before comparing values.
Select one of the following options:
  • None. Does not trim leading or trailing spaces.
  • Both. Trims both leading and trailing spaces.
  • Leading. Trims leading spaces.
  • Trailing. Trims trailing spaces.
Maximum foreign keys returned
Maximum number of matched foreign key results that you want to return.
Minimum confidence percent
Minimum percentage of foreign key values that match the inferred datatype.
Regenerate signature
Determines whether the data profiling warehouse should clear the existing object information before the Data Integration Service runs the profile.