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. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

Substitution Masking Parameters

Substitution Masking Parameters

You can substitute data with repeatable or non-repeatable values.
When you choose repeatable values, the
Integration Service
produces deterministic results for the same source data and seed value. You must configure a seed value to substitute data with deterministic results.
You can configure the following substitution masking parameters:
Parameter
Description
Repeatable Output
Returns deterministic results between sessions. The
Integration Service
saves masked values in the storage table.
Seed
A start number that the
Integration Service
uses to return deterministic data.
Unique Substitution Data
Replaces the target column with unique masked values for every unique source column value. If there are more values in the source than in the dictionary file, the data masking operation fails because the dictionary file does not contain sufficient unique values to substitute the data. For security, the default is nonunique substitution.
Optimize Dictionary Usage
Applicable if you select the Repeatable Output option. Increases the usage of masked values from the dictionary.
This option is not available if you enable the Unique Substitution Data option.
If you used the option in a masking rule in an earlier version, and want to consistently mask the source data in 10.5, you must enable the old dictionary optimization algorithm. See Project Configuration for the Old Dictionary Optimization Algorithm.
Dictionary Information
Required. Configuration of the flat file or relational table that contains the substitute data values. Configure the following parameters:
  • Dictionary. Displays the flat file or relational table name that you select.
  • Masked Value. The column returned to the masking rule.
  • Lookup Column. The source data column to use in the lookup.
  • Serial Number Column. The column in the dictionary that contains the serial number.
  • Sort Column. The dictionary column on which you want to sort entries.
    Enter this property to generate deterministic results if you move a relational dictionary to a different database. For example, if you move a relational dictionary and the order of entries changes, sort on the serial number column to consistently mask the data.