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 Builder

Expression Builder

Use the
Expression Builder
to build an expression using PowerCenter 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.
  • Configure expressions in an ad hoc generation rule.
  • Configure advanced expressions in plans.
The
Expression Builder
shows a list of PowerCenter 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
.