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

Parameters in Entity Criteria

Parameters in Entity Criteria

You can use parameters to specify the filter criteria to create a data subset. Parameters allow you to change values each time you run a workflow without editing a plan.
You can create criteria parameters in a project or use global parameters that an Administrator creates. Maintain the parameter values in the project or in an external parameter file.
A parameter file is a file that lists user-defined parameters and their values. When you use parameters to specify the filter criteria in an entity, you select a parameter name instead of entering a specific value in the criteria.
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 select the name of the parameter. Enter the parameter value as 100 in the parameter file.
Global parameters are indicated with an asterisk (*) in the list of parameters.
Create a criteria parameter CRITERIAVALUE in the project or at a global level. If you include a parameter file in the workflow that you run, the parameter file must contain an entry $$CRITERIAVALUE=100.
Add the criteria EMPID > CRITERIAVALUE in the entity.
To create a data subset with a different filter criteria value, you can change the value of the parameter and run the same workflow. To create a data subset that contains rows with EMPID greater than 500, change the parameter value to 500 and then run the workflow.
Enter the parameter file name and the file path when you configure the plan and run the workflow.
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.
Enter the criteria as a value in the SQL query.
You can include multiple filter criteria parameters in an entity. You can choose to include the criteria parameters that you want each time you run the workflow. If you maintain the parameter values in the project, choose to include the criteria parameters that you want in the
Execute Workflow
window.
If you maintain the parameter values in a parameter file that you create, you must create ignore flags for each criteria parameter. Set the flag to "Y" or "N" to ignore the criteria or consider the criteria in a workflow. A workflow does not consider criteria that you flag for ignore.
For example, the criteria parameter CRITERIAVALUE must have a corresponding $$CRITERIAVALUE_IGNORE flag. Set the flag value to "N" to include the criteria in a workflow. Set the flag to "Y" to ignore the criteria in the workflow.
If you create the parameter file in Test Data Manager, the file contains ignore flags for each criteria parameter. By default, the flag is set to "N".