Configure one unmasking operation for each part of the input phone
numbers. Separators will be left unchanged in the unmasked values.
In the Modifications table, the
settings must be the same as the ones used for the masking operations performed by the
tPatternMasking component.
About this task
The masked 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 tPatternUnmasking 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.
tPatternUnmasking 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.
-
In the Modifications
table, click the [+] button to add three
rows.
Each row corresponds to an unmasking operation for a part of
the input phone numbers.
-
In the Modifications
table, edit the first row to configure the unmasking operation for
prefixes:
-
From the Column to
unmask field, select the column which holds the data to
be unmasked.
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.
-
In the Modifications
table, edit the second row to unmask the first four-digit line numbers:
-
From the Column to
unmask field, select the column which holds the data to
be unmasked.
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.
-
In the Modifications
table, configure the third row to unmask the second four-digit line
numbers:
-
From the Column to
unmask field, select the column which holds the data to
be unmasked.
In this example, select PhoneNumber.
-
From the Field
type field, select Interval as the field type the data belongs to and
enter "0000,99999" in the
Range field.
-
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 the method used when the data was masked using the
tPatternMasking component.
Example
In this example, select
FF1 with
AES.
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 or 256-bit key for FF1 methods field, enter
the user-defined password used when the data was masked using the
tPatternMasking component.
Example
In this example, enter "talend".
