August 15, 2023

Replacing actual data with realistic values – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Replacing actual data with realistic values – Docs for ESB 6.x

Replacing actual data with realistic values

  1. Double-click tDataMasking to display the
    Basic settings view and define the component
    properties.

    use_case-tdatamasking4.png

  2. If required, click Sync columns to retrieve
    the schema defined in the input component.
  3. Click the Edit schema button to open the
    schema dialog box.

    tDataMasking proposes one predefined
    read-only column as shown in the below capture.
    use_case-tdatamasking5.png

    This column identifies by true or false if the
    output record is an original or a substitute record respectively.
  4. 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.
  5. In the Modifications table, click the
    [+] button to add four rows, and
    then:

    • 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.

    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.
  6. 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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x