Configuring the masking operations – Talend Open Studio for ESB Document 7.x

Configuring the masking operations

Configure one masking operation for each part of the input phone numbers.
Separators will be left unchanged in the masked values.

In this Job, the fictitious Australian phone numbers use the XX XXXX
XXXX format:

  • A two-digit prefix
  • A space used as a separator
  • A four-digit code region
  • A space used as a separator
  • A four-digit line number
  1. Double-click tPatternMasking to display its
    Basic settings view in the
    Component tab.

    Configuring the masking operations_1.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.

    tPatternMasking adds a read-only column to the output
    schema.

    Configuring the masking operations_2.png

    The ORIGINAL_MARK column labels output records:

    • Original records are labeled with the true label.
    • Substitute records are labeled with the false
      label.
  4. 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.
  5. In the Modifications table, configure the first
    row:

    1. From the Column to mask field, select the column
      which holds the data to be masked.

      In this example, select PhoneNumber.
    2. 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 prefixes will be masked with one of those values.
  6. In the Modifications table, configure the second
    row:

    1. From the Column to mask field, select the column
      which holds the data to be masked.

      In this example, select PhoneNumber.
    2. From the Field type field, select
      Enumeration as the field type the data
      belongs to and enter "5550,7010" in the
      Values field.

      Four-digit code regions will be masked with one of those values.
  7. In the Modifications table, configure the third
    row:

    1. From the Column to mask field, select the column
      which holds the data to be masked.

      In this example, select PhoneNumber.
    2. From the Field type field, select
      Interval as the field type the data belongs
      to and enter "0000,99999" in the
      Range field.

      Four-digit line numbers will be masked with a value within the defined
      range.
  8. Click the Advanced settings tab and select the
    Output the original row? check box.

    The Job will output original and substitute records.
  9. From the Method list, select FF1 with
    AES     to generate encrypted masked values.
  10. In the Password for FF1 methods, enter a password to
    generate unique masked values.

    This password is also necessary to unmask data.
Document get from Talend https://help.talend.com
Thank you for watching.
Tagged:

Related Post:

  1. tSplunkEventCollector – Talend Open Studio for ESB Document Splunk 7.x
  2. tSnowflakeOutputBulk – Talend Open Studio for ESB Document Snow Flake 7.x
  3. tDBRow – Talend Open Studio for ESB Document Snow Flake 7.x
  4. tMysqlBulkExec Standard Properties – Talend Open Studio for ESB Document Snow Flake 7.x
  5. tS3Configuration properties for Apache Spark Batch – Talend Open Studio for ESB Document Snow Flake 7.x
  6. tSnowflakeRollback Standard properties – Talend Open Studio for ESB Document Snow Flake 7.x
  7. tDBCDC – Talend Open Studio for ESB Document Snow Flake 7.x
  8. tSnowflakeBulkExec – Talend Open Studio for ESB Document Snow Flake 7.x
  9. tDBOutput – Talend Open Studio for ESB Document Snow Flake 7.x
  10. tSnowflakeInput – Talend Open Studio for ESB Document Snow Flake 7.x
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments