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

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