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. 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. Glossary

Parameter Values in Entity Criteria

Parameter Values in Entity Criteria

A parameter file is an XML file that lists user-defined parameters and their assigned values. You can use parameters when you specify the criteria to create a data subset. Parameter files provide the flexibility to change parameter values each time you run a workflow.
When you use parameters to specify the criteria, you enter a parameter name instead of a specific value.
For example, you want to create a data subset that includes all rows with the EMPID greater than 100. Instead of entering the value as 100 in the value field, you enter the name of the parameter. Enter the parameter value as 100 in the parameter file.
Enter the criteria EMPID > $PARAMETERVALUE. The parameter file must contain an entry $PARAMETERVALUE=100.
Enter the parameter file name and the file path when you configure the plan.
When you use parameters for a string field or a date field on a relational source, you must enclose the value in single quotes in the parameter file.