Transformation Guide

Back Next

Applying Masking Rules

Apply masking rules based on the source datatype. When you click a column property on the Masking Properties tab, the Designer displays masking rules based on the datatype of the port.

The following table describes the masking rules that you can configure based on the masking type and the source datatype:

Masking Types	Source Datatype	Masking Rules	Description
Random and Key	String	Mask Format	Mask that limits each character in an output string to an alphabetic, numeric, or alphanumeric character.
Random and Key	String	Source String Characters	Set of source characters to mask or to exclude from masking.
Random and Key	String	Result String Replacement Characters	A set of characters to include or exclude in a mask.
Random	Numeric String Date/Time	Range	A range of output values. Numeric. The Data Masking transformation returns numeric data between the minimum and maximum values. String. Returns a string of random characters between the minimum and maximum string length. Date/Time. Returns a date and time within the minimum and maximum datetime.
Random	Numeric Date/Time	Blurring	Range of output values with a fixed or percent variance from the source data. The Data Masking transformation returns data that is close to the value of the source data. Datetime columns require a fixed variance.