Double-click tDataMasking to display the
Basic settings view and define the component
- 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
falseif 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
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 finally replace the part before the @ sign in email addresses by a series of X.
in the Input Column, select the columns which content you want to substitute,
in the Function column, select from the predefined list the function you want to use to generate the substitute data,
in the Parameter column, enter a value, a pattern or a path to be used by the function to substitute data.
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.