Configure one masking operation for each part of the input phone numbers.
Separators will be left unchanged in the masked values.
About this task
In this Job, the fictitious Australian phone numbers use the
XX XXXX
XXXX
format:- A two-digit area code
- A space used as a separator
- A first four-digit line number
- A space used as a separator
- A second four-digit line number
Procedure
-
Double-click tPatternMasking to display its
Basic settings view in the
Component tab.
- If required, click Sync columns to retrieve the schema defined in the input component.
-
Click the Edit schema button to open the schema dialog
box.
tPatternMasking adds a read-only column to the output schema.
The ORIGINAL_MARK column labels output records:
- Original records are labeled with the
true
label. - Substitute records are labeled with the
false
label.
- Original records are labeled with the
-
In the Modifications table, click the
[+] button to add three rows.
Each row corresponds to a masking operation for a part of the input phone numbers.
-
In the Modifications table, configure the first
row:
-
From the Column to mask field, select the column
which holds the data to be masked.
In this example, select PhoneNumber.
-
From the Field type field, select
Enumeration as the field type the data
belongs to and enter "02,03,07,08" in the
Values field.
Two-digit area code will be masked with one of those values.
-
From the Column to mask field, select the column
which holds the data to be masked.
-
In the Modifications table, configure the second
row:
-
From the Column to mask field, select the column
which holds the data to be masked.
In this example, select PhoneNumber.
-
From the Field
type field, select Interval as the field type the data belongs to and
enter "2000,9999" in the
Range field.
Four-digit line numbers will be masked with one of those values.
-
From the Column to mask field, select the column
which holds the data to be masked.
-
In the Modifications table, configure the third
row:
-
From the Column to mask field, select the column
which holds the data to be masked.
In this example, select PhoneNumber.
-
From the Field
type field, select Interval as the field type the data belongs to and
enter "0000,9999" in the
Range field.
Four-digit line numbers will be masked with a value within the defined range.
-
From the Column to mask field, select the column
which holds the data to be masked.
-
Click the Advanced settings tab and select the
Output the original row? check box.
The Job will output original and substitute records.
-
From the Method list, select FF1 with
AES to generate encrypted masked values.
When you use a FF1 method, the number of possible values that the component can generate from the input pattern must be greater than or equal to 1,000,000.
-
In the Password for FF1 methods, enter a password to
generate unique masked values.
This password is also necessary to unmask data.