Configuring the output component and executing the Job - 7.0

Data privacy

author
Talend Documentation Team
EnrichVersion
7.0
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Data privacy components
Data Quality and Preparation > Third-party systems > Data Quality components > Data privacy components
Design and Development > Third-party systems > Data Quality components > Data privacy components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tFileOutputExcel component to display the Basic settings view and define the component properties.
  2. Set the destination file name as well as the sheet name and then select the Define all columns auto size check box.
  3. Save your Job and press F6 to execute it.
    The tDataMasking component substitutes data in the selected columns and writes the result in an output file.
  4. Right-click the output component and select Data Viewer to display the original and substituted data.
    tDataMasking outputs original and substitute rows marked respectively with true and false in the ORIGINAL_MARK column. It generates inauthentic credit card numbers, replaces the first three letters of first names, replaces last names with names from a local file and finally replaces the part before the @ sign in email addresses by the names defined in the component basic settings.
    Sensitive personal information in the input data has been "hidden" but data keeps looking real and consistent. The substitute data is still usable for purposes other than production.