Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Parameter files in data filters

Parameter files in data filters

In a
masking
task, you can use user-defined parameters in simple and advanced data filters.
When you use a parameter in a filter, start the filter with the parameter. Use two dollar signs to name the parameter in the following format:
$$<parameter>
Save the parameter file local to the following directory:
<Secure Agent installation directory>/apps/Data_Integration_Server/data/userparameters
You can specify the parameter file name on the Schedule page of the task wizard. The parameter values are applied when the task runs.
Simple Filter Example
Consider that you apply a filter on the Account object. Configure the filter condition that the Created Date must be equal to $$param. Then create a parameter file with the following content:
$$param=('1991-10-03')
The following image shows a simple filter with the use of a parameter:
The Data Filter dialog box shows a simple filter that is applied on the Account object. The filter applied is that the Created Date must be equal to $$param.
Advanced Filter Examples
Consider that you apply a filter on the Account object. In the Advanced Data Filter dialog box, you can specify the filter expression that the Account Name field must pick all the values from $$param. Then create a parameter file with the following content:
$$param=('Apple' , 'Microsoft')
The following image shows an advanced filter with the use of parameter as a value:
The Advanced Data Filter dialog box shows that the filtered object is Account, the list of fields, and a filter expression. The following filter expression is entered: Account.Name IN $$param
You can also specify a filter expression as a parameter. Enter $$param as the filter expression. Then create a parameter file with the following content:
$$param=Name IN ('Apple' , 'Microsoft')
The following image shows an advanced filter with the use of a parameter as an expression:
The Advanced Data Filter dialog box shows that the filtered object is Account, the list of fields, and a filter expression. The following filter expression is entered: $$param

0 COMMENTS

We’d like to hear from you!