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. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Constraints

Constraints

Foreign key constraints define parent-child relationships between the source tables. Use constraints to determine the tables to include in a data subset. You can also limit the values that you want to store in the data subset table columns.
Use data discovery to find relationships between tables. When you identify the relationships that you want to add to the TDM repository, create and edit constraints in Test Data Manager.
The following types of constraints define relationships between tables:
Primary Key
A column or combination of columns that uniquely identifies a row in a data source. A table can have one primary key.
Logical Manual
A parent-child relationship between tables based on columns that are not keys. You can create the following logical constraints:
  • Logical constraints that you accept from data discovery profiles. You can delete these logical constraints.
  • Logical constraints that you define in Test Data Manager. You can delete these logical constraints.