SAP BODS 4.2 has new transformation called “Data Mask” ,which is used toenables the data masking functionality .
Eg: Protect personally identifications ids (like SSN, PAN, etc..) and information in your data. Personal information includes data such as credit card numbers, sal information, dob, phone numbers, credit card numbers or bank account numbers. You may want to use data masking to support security and privacy policies, and to protect your customer or employee information from possible missuses.
I have created a source table with data as looks below.
After masking the results would be
This will explain the steps to mask the personal information like ID,CC and EMAIL.
SAP BODS Data Mask Transformation:
Created a Data flow with source-->Data Mask-->Target mapping.
Data Mask Transformation Properties :
Data Mask transform has 3 tabs 1.Input 2.Option 3.Output tabs