-
Double-click tDataMasking to display the
Basic settings view and define the component
properties.
-
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.
tDataMasking proposes one predefined
read-only column as shown in the below capture.
This column identifies by true or false if the
output record is an original or a substitute record respectively.
-
Move any of the input columns to the output schema if you want to show them in
the results, click OK and accept to propagate
the changes.
-
In the Modifications table, click the [+] button to add four rows, and
perform the following actions:
- In the Input Column, select the
columns which content you want to substitute.
- In the Category column, select
from the list the category the function you want to use to mask data
belongs to.
- In the Function column, select
from the list the function you want to use to mask data.
- When available, in the Parameter
column, select from the list the method to be used by the function to
mask data.
- When available, in the Parameter
column, enter a value, a pattern or a path to be used by the function to
mask data.
In this example, the Job will generate
inauthentic credit card numbers, replace the first three letters of first names,
replace last names with names from a local file and replace the local part in
email addresses with X
characters.
-
Click the Advanced settings tab and select
the Output the original row check box.
The Job will add the original data rows to the substitute data.
This column identifies by