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

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.