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. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. 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.