Configuring the output component and executing the Job - 7.2

Data privacy
Version
7.2
Language
English (United States)
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
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

Procedure

  1. Double-click the tLogRow component to display the Basic settings view and define the component properties.
  2. Click Sync columns button to retrieve the schema defined in the preceding component.
  3. Select Table in the Mode area.
  4. Save your Job and press F6 to execute it.

Results

The tPatternMasking component alters the values from the input data and outputs original and substitute records.

The first record is labeled as true because FR 30002 00550 0000157841Z is an original record. The second record is labeled as false because FR 29943 00650 007855D1OAP is a substitute record.

The first two characters are replaced with "FR", as defined in the tPatternMasking properties.

The next five characters are replaced with one of the values from the specified set of named values: "30002,29943,23332,01242".

The next five characters are replaced with a value from the specified range: "0,99999".

Each of the next eleven characters is replaced with a random character from the specified set of named values: "0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z".

The input values use spaces as separators and spaces are unchanged in the output data.

The input data has been altered but the output data look real and consistent. The substitute data is still usable for non-production purposes.