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

SSN masking

SSN masking

SSN masking applies a built-in mask format to change Social Security numbers.
The SSN masking accepts any SSN format that contains nine digits. You can delimit the digits with any characters. The following delimiters are valid:
space, no space, #, +, -, *, =, ~, !, @, $, %, ^, &, *, :, ;, ", ., /, and ,
For example, the SSN masking rule accepts the following format:
+=54-*9944$#789-,*()”
The following examples of Social Security numbers are valid formats:

    123456789

    123 45 6789

    123-45-6789

If the source does not contain a valid format, the task replaces with default values from the
defaultValue.xml
file.
You can configure repeatable masking for Social Security numbers. You must select
Repeatable
and enter a seed value.
The
masking
task cannot return all unique Social Security numbers because it does not return valid Social Security numbers that the Social Security Administration has issued.

0 COMMENTS

We’d like to hear from you!