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

Key string masking

Key string masking

Configure key string masking to mask all or part of a string. To limit the masking output to certain characters, specify a mask format and result string replacement characters. If you need repeatable output, specify a seed value.
The following table describes the parameters that you can use with key masking:
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.
Mask Format
The type of character to substitute for each character in the source data. You can limit each character to an alphanumeric, numeric, or character type.
Filter Source
Determines whether to skip masking some of the source characters. Configure the Source Filter Type and the Source Filter Chars parameters when you enable this option. Default is disabled.
Source Filter Type
A filter that determines which characters to mask in the source. Use with the Source Filter Chars parameter. You must enable the Filter Source parameter to configure this parameter.
Choose one of the following options:
  • Mask Only. Mask only the characters that you configure as source filter characters.
  • Mask All Except. Mask all characters except the characters you configure as source filter characters.
Source Filter Chars
The source characters that you want to mask or the source characters that you want to skip masking. Each character is case-sensitive. Enter the source filter characters with no delimiters. For example,
AaBbC
.
Filter Target
Determines whether to limit the characters that can appear in the target. Configure the Target Filter Type and the Target Filter Chars parameters when you enable this option. Default is disabled.
Target Filter Type
A filter that determines which characters to use in the target mask. Use with the Target Filter Chars parameter. You must enable the Filter Target parameter to configure this parameter.
Choose one of the following options:
  • Use Only. Limit the target to the characters that you configure as target filter characters.
  • Use All Except. Limits the target to all characters except the characters you configure as target filter characters.
Target Filter Chars
The characters that you want to use in a mask or the characters that do not want to use in a mask, based on the values of target filter type. Each character is case-sensitive. Enter the target filter characters with no delimiters. For example,
AaBbC
.

0 COMMENTS

We’d like to hear from you!