Double-click the tLogRow component to display the
Basic settings view and define the component
- Click Sync columns button to retrieve the schema defined in the preceding component.
- Select Table in the Mode area.
- Save your Job and press F6 to execute it.
The tPatternMasking component alters the values from the input data and outputs original and substitute records.
The first record is labeled as
FR 30002 00550
0000157841Z is an original record. The second record is labeled as
FR 29943 00650 007855D1OAP is a
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.