The Data Masking transformation returns an email address of random characters when it masks an email address.
For example, the Data Masking transformation can mask Georgesmith@yahoo.com as KtrIupQAPyk@vdSKh.BICJ.
When you use the email masking format, you must set the seed value. The seed value is a random number from 1 through 999 and is a starting point to generate masked values. You can enter a different seed value. Apply the same seed value to a column to return the same masked data values in different source data. For example, you have the same Cust_ID column in four tables. You want all of them to output the same masked values. Set all four columns to the same seed value.
Advanced email masking
You can create a realistic email address from a first name, last name, and domain name.
When you configure advanced email masking, you can configure parameters to mask the user name and the domain name in the email address. For example, a source table might contain columns called First_Name and Last_Name. You can configure the email address to contain the first character of First_Name and seven characters of the last name. Define a domain name for the email address. The Masking task creates an address with the following syntax:
VSingh@mycompany.com
The following table describes the parameters you can configure for advanced email masking:
Parameter
Description
Repeatable
Returns the same masked value when you run a task multiple times or when you generate masked values for a field that is in multiple tables.
Seed Value
A starting number to create repeatable output. Enter a number from 1 through 999. Default seed value is 190. You can enter the seed value as a parameter.
First Name
Name of the column to use as the first part of the email name. The email name contains the masked value of the column you choose.
First Name Length
The number of characters in the first name to include in the email address.
Delimiter
Delimiter, such as a dot, hyphen, or underscore, to separate the first name and last name in the email address. If you do not want to separate the first name and last name in the email address, leave the delimiter blank.
Last Name
Name of the masked column to use in the email name. The email name contains the masked value of the column you choose.
Last Name Length
The number of characters in the last name to include in the email address.
Domain Name
A string value that represents an Internet Protocol (IP) resource such as gmail.com.