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. Data Sets
  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. Data Type Reference for Hadoop
  22. Glossary

Shuffle Masking

Shuffle Masking

Shuffle masking masks the data in a column with data from the same column in another row of the table. Shuffle masking switches all the values for a column in a file or database table. You can restrict which values to shuffle based on a lookup condition or a constraint. Mask date, numeric, and string datatypes with shuffle masking.
For example, you might want to switch the first name values from one customer to another customer in a table. The table includes the following rows:
100 Tom Bender 101 Sue Slade 102 Bob Bold 103 Eli Jones
When you apply shuffle masking, the rows contain the following data:
100 Bob Bender 101 Eli Slade 102 Tom Bold 103 Sue Jones
You can configure shuffle masking to shuffle data randomly or you can configure shuffle masking to return repeatable results.
You cannot use shuffle masking to mask Hadoop data.
If the source file might have empty strings in the shuffle column, set the
Null and Empty Spaces
option to Treat as Value in the rule exception handling. When you set the option to Treat as Value, the PowerCenter Integration Service masks the space or the null value with a valid value. The default is to skip masking the empty column.