Table of Contents


  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

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
On an XSD source, you cannot apply a conditional constraint on an element if the
Child Records for each Parent
property value is greater than 1. For example, if you set the
as 0 and the
as 5 for an element, there can be up to 5 child records for each parent record. You cannot apply a conditional constraint on the element.

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