Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

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 PowerCenter 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.
For information about expression syntax, see the
Informatica Transformation Language Reference
.