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

Substitution Masking Parameters

Substitution Masking Parameters

You can substitute data with repeatable or non-repeatable values.
When you choose repeatable values, the
PowerCenter 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
PowerCenter Integration Service
saves masked values in the storage table.
Seed
A start number that the
PowerCenter 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
Required 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.
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.