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. 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

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.