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. Working with Test Data Warehouse
  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. Glossary

Advanced Masking Example

Advanced Masking Example

You can create an expression to combine multiple columns in an advanced masking rule.
Create an expression in the
Expression Builder
. Select columns, functions, variables, and operators to build expressions. The expression can reference input columns and variable columns.
For example, you have a CUSTOMERS table that contains first and last names. You want to mask the names and combine the masked values into a masked full name.
The following table shows the columns that you create in an the advanced masking rule to combine the masked names:
Column Name
Column Type
Masking Technique
Expression
FIRST_NAME
INPUT
LAST_NAME
INPUT
FIRST_MASKED
VARIABLE
Substitution on FIRST_NAME
_
LAST_MASKED
VARIABLE
Substitution on LAST_NAME
_
FULL_NAME
OUTPUT
Expression
FIRST_MASKED || ' ' || LAST_MASKED
Mask the FIRST_NAME and LAST_NAME with Substitution. Return FULL_NAME using an expression that combines the FIRST_MASKED and LAST_MASKED columns.
When you create expressions in the Expression Builder, use the point-and-click interface to minimize errors. Verify that the expression returns a value that matches the output column data type.