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

Creating an Entity Profile

Creating an Entity Profile

The entity profile creates a list of possible parent tables that you can define for data subset operations. Create and run entity profiles in the
Discover
view.
  1. Open the project, and click the
    Discover
    view.
  2. Click the
    Profile
    view.
    The
    Profile
    view shows a list of the profiles in the project.
  3. Click
    Actions
    New Profile
    to create a profile.
  4. In the
    New Profile
    dialog box, enter the profile name and description. Choose to create an entity profile.
    Select primary key and entity profile if the physical database does not contain any primary keys.
  5. Click
    Next
    .
  6. Select the tables to profile, and click
    OK
    .
  7. Click
    Next
    .
  8. In the
    Sampling Options
    page, enter the maximum number of columns that you want to include in the primary key.
  9. Enter the maximum number of rows that you want to run the profile on.
  10. Enter the minimum conformance required, or enter the maximum number of rows that can violate the criteria.
    The following table describes the entity options that you can update:
    Entity Option
    Description
    Data types used in comparison
    Determines how Test Data Manager derives data types to compare in the tables.
    Choose one of the following options:
    • Inferred data types. Compares the primary key and the foreign key based on the data types inferred by TDM.
    • Documented data types. Compares the primary key and the foreign key based on the data types defined for the source column.
    Comparison case sensitivity
    Indicates if the foreign key comparison is case-sensitive or not. If you choose case-sensitivity, profile performance might be affected.
    Trim values before comparison
    Trims leading values, trailing values, or leading and trailing values.
    Minimum conformance percent
    Minimum percentage of rows without key violations that the profile allows for foreign key discovery.
    Regenerate Signature
    Determines whether the data profiling warehouse should clear the existing object information before the Data Integration Service runs the profile.
  11. Click
    Save
    .
  12. Click
    Actions
    Execute
    to run the profile.