Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. 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.
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.