Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

Expression Masking

Expression Masking

Expression masking applies an expression to a column to mask or change data. Mask all data types with expression masking.
To configure expression masking, you create an expression in the
Expression Builder
.
Select column, functions, variables, and operators to build expressions. The expression can reference input columns and output columns.
In expression masking, you can append additional data to the source column data. For example, you want to mask the first names. The source has the FirstName column and you want to concatenate the values in the FirstName column with the string ABC. When you configure the data masking rule, select the FirstName column and enter the following expression in the expression editor.
CONCAT(FirstName,'ABC')
When you configure expression masking for a column, the column name appears as the expression by default.
Select functions, columns, variables, and operators from the point-and-click interface to minimize errors when you build expressions.
When you create an expression, verify that the expression returns a value that matches the column data type. The
Data Integration Service
returns zero if the return value does not match a numeric column. It returns NULL if the return value does not match a string column.
You cannot perform expression masking with repeatable output for Hadoop data sources.
For information about expression syntax, see the
Informatica Transformation Language Reference
.