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

Conditional Constraints

Conditional Constraints

Create conditional constraints to restrict the data that you want to generate in a column based on the data in another column. The conditional constraint that you enter becomes a part of the metadata of the target table.
Configure expressions to apply constraints at the table level. Use the
Expression Builder
to enter the expressions. You can create multiple conditional constraints for a table.
You cannot use conditional constraints for the following data generation techniques:
  • Numeric sequence
  • Date sequence
  • Random data patterns

Conditional Constraints Example

You have a table that contains airline ticket information and you want to generate airport codes in From_City and To_City columns in the table. You create and assign a dictionary generation rule to the columns. You do not want the From_City column and the To_City column to have the same value in a row. You create a conditional constraint and enter the following expression in the
Expression Builder
:
To_City != From_City
When you perform the data generation operation, TDM adheres to the conditional constraint and generates data in the From_City and To_City columns.
The following table lists sample flight details with generated data:
Flight Code
From_City
To_City
11A1
BOS
SFO
22B2
AUS
EWR
33C3
SEA
JFK