Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: 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.