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. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

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.
  • Configure expressions in an ad hoc generation rule.
  • Configure advanced expressions in plans.
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
.