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

SIN masking

SIN masking

SIN masking applies a built-in mask format to change Social Insurance numbers.
You can mask a Social Insurance number that is nine digits. The digits can be delimited by any set of characters. The following delimiters are valid:
space, no space, #, +, -, *, =, ~, !, @, $, %, ^, &, *, :, ;, ", ., /, and ,
If the number contains no delimiters, the masked number contains no delimiters. Otherwise the masked number has the following format:
xxx-xxx-xxx
The following examples of Social Insurance numbers are valid formats:

    123456789

    123 456 789

    123-456-789

If the source does not contain a valid format, the task replaces with default values from the
defaultValue.xml
file.
You can define the first digit of the masked SIN. Enable
Start Digit
and enter the digit. The
masking
task creates masked SIN numbers that start with the number that you enter. You can configure repeatable masking for Social Insurance numbers. To configure repeatable masking for SIN numbers, select
Repeatable
and enter a seed value.
The following table describes the parameters you can configure for SIN 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.
Start Digit
When enabled, you can define the first digit of the masked SIN.
Start Digit Value
The value for the first digit of the masked SIN.

0 COMMENTS

We’d like to hear from you!