Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Plans and Workflows
  11. Monitor
  12. Reports
  13. ilmcmd
  14. Data Type Reference
  15. Data Type Reference for Hadoop

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.
  • Log error and continue. Log an error in the 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.
  • Log exception and continue. Log an exception in the session log and continue processing.
  • Ignore and continue. Do not mask the null or empty space.
  • Error. Log an error in the 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 " .