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

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
Patrick
Price
Price, Patrick
Patrick Price, General Manager
Jennifer
Town
Town, Jennifer
Jennifer Town, Department Head
When you specify space and comma as delimiters, the workflow identifies the first and last names when they appear as substrings in other columns.