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. Data Type Reference for Hadoop
  23. Glossary

Delimited String Masking

Delimited String Masking

Consistently mask a data substring that occurs anywhere in the data.
A string of data that occurs in a column might appear as a substring in other columns. For example, a first name and last name might appear as strings in a First Name column and a Last Name column, but as substrings in a Full Name column or a Description column.
You might want to mask the first and last names consistently in all columns that they appear in, even as substrings.
You can configure a key string masking rule to include delimited string masking and specify delimiters to identify substrings.
Consider the following data:
First Name
Last Name
Full Name
Description
John
Donne
Donne, John
John Donne, General Manager
Janice
Baker
Baker, Janice
Janice Baker, Department Head
Data that appears as a string in one column appears as a substring in other columns. If you assign the Key masking technique for string data to the First Name and Last Name columns, you ensure that you mask a string with the same value each time it occurs as a string.
You can choose to configure delimited string masking on columns where the strings might appear as substrings. Specify delimiters to determine substrings. In the example, you assign delimited string masking to the Full Name and Description columns and specify comma and space as delimiters.
The masked data in the target could appear as:
First Name
Last Name
Full Name
Description
zOQF
TOIFD
TOIFD, zOQF
zOQF TOIFD, 9dI8XUB 3nI3MkF
znIwdk
7nz8X
7nz8X, znIwdk
znIwdk 7nz8X, Tdx3XHNafP Wdyz
When you specify space and comma as delimiters, the workflow identifies the first and last names when they appear as substrings in other columns.