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

Substitution masking parameters

Substitution masking parameters

To perform substitution masking, you can select one of the dictionaries that the
masking
task provides.
The following table describes the parameters that you can configure for substitution masking:
Parameter
Description
Repeatable
Returns the same masked value when you run a task multiple times or when you generate masked values for a field that is in multiple tables.
Seed Value
A starting number to create repeatable output. Enter a number from 1 through 999. Default seed value is 190. You can enter the seed value as a parameter.
Optimize Dictionary Usage
Increases the usage of masked values from the dictionary. Available if you choose the
Repeatable
option. The property is not applicable if you enable unique substitution.
Is Unique
Applicable for repeatable substitution. Replaces the target column with unique dictionary values for every unique source column value. If there are more unique values in the source than in the dictionary file, the data masking operation fails. Default is nonunique substitution.
Preprocessing Expression
Configure an expression in the rule to convert characters before the masking rule runs. For example, you might want to convert all characters to the same case before masking.
Postprocessing Expression
Configure an expression in the rule to convert characters in the masked output before the data is copied to the target.

0 COMMENTS

We’d like to hear from you!