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

Exception Handling

Exception Handling

Data masking exception handling defines options for handling nulls, blanks, empty strings, and errors in source data. You can configure exception handling for each data masking rule that you create. You can specify preprocessing and post processing expression parameters to apply changes before and after masking the data.
The following table describes the exception handling options:
Option
Description
Preprocessing Expression
Optional. Expression to define changes to make to the data before masking. Click
Edit
to configure the preprocessing expression.
Post processing Expression
Optional. Expression to define changes to make to the masked data before saving the data to the target. Click
Edit
to configure the post processing expression.
Null and Empty Spaces
The default behavior for handling null values or empty columns in the source data. Choose one of the following options:
  • Constant. Mask the data with a constant value. Enter the value to use.
  • Default server value. Mask the source column with the default value from thedefaultValue.xml file.
  • Log error and continue. Log an error in the PowerCenter session log and continue processing.
  • Treat as value. Treat null values or spaces as a valid source value. Mask the space or null value with a valid value.
  • Ignore. Do not mask the null or empty space.
For columns with dependent masking, there are no separate rules to handle null and empty spaces. TDM masks the dependent column based on the rules and values of the column that it depends on.
Error Handling
The default behavior for handling errors in the source data. Choose one of the following options:
  • Constant. Mask the data with a constant value. Enter the value to use.
  • Default server value. Mask the source column with the default value from thedefaultValue.xml file
  • Log exception and continue. Log an exception in the PowerCenter session log and continue processing.
  • Ignore and continue. Do not mask the null or empty space.
  • Error. Log an error in the PowerCenter session log and stop processing.
Trim Leading or Trailing Spaces
Trims the leading and trailing spaces from source data. When you enable this option the following source fields are the same: " Jones", "Jones", "Jones " .