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