Use the Data Masking transformation to change sensitive production data to realistic test data for non-production environments. The Data Masking transformation modifies source data based on masking rules that you configure for each column. Create masked data for software development, testing, training, and data mining. You can maintain data relationships in the masked data and maintain referential integrity between database tables.The following example shows how to use the Expression transformation with the Data Masking transformation to maintain a relationship between two columns after you mask one of the columns. This example includes the following types of masking:

• Key
• Date blurring
• Number blurring
• Mask formatting