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. 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. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Creating a Primary Key Profile

Creating a Primary Key Profile

Create a primary key profile to identify a list of possible primary keys that you can add to tables without keys. Create a primary key profile if the source data does not contain primary and foreign key relationships.
  1. Open the project, and click the
    Discover
    view.
  2. Click the
    Profile
    view.
  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 a primary key profile.
  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.
  11. Click
    Finish
    .
  12. Click
    Actions
    Execute
    .