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 Builder

Expression Builder

Use the
Expression Builder
to build an expression using functions.
Click
Expression
to open the
Expression Builder
when you perform any of the following tasks:
  • Create masking rules with Expression masking type.
  • Add pre-processing or post-processing expressions to a standard masking rule.
  • Create advanced masking rules.
  • Assign rules to a column.
The
Expression Builder
shows a list of functions by category. To view the complete list, expand the
All Functions
list.
You can choose from a list of available columns to include in an expression. Select a function and click the
Add
arrow to add the function to an expression. You can choose columns and operators to enter join conditions.
For example, you might create an advanced masking rule that contains a first name and a last name input port. The masking rule has two variable ports that receive masked values for the first name and the last name. You might create an expression for the output port that concatenates the masked names in the variable ports and includes a space between them:
CONCAT( CONCAT( VAR1, ' ' ), VAR2 )
The following image shows the
Expression Builder
where you configure expressions:
The Configure Expression dialog box shows functions and columns tabs on the left side and expressions and join condition on the right side. Functions show a list of available functions that you can add into the expression editor.
For more information about the function syntax, see the
Informatica Transformation Language Reference
.