Translate Table Access Path Failed

Access path failed options are specified for the translate table, and all access paths created for that table use the same options.

The access path failed options define the default actions to take when no replacement row is identified or the source value is longer than expected.

A status indicator is associated with each translate rule action that denotes whether the access was successful. The status indicator can be checked by using the IS_ACCESS_PATH_FAILED function within rule logic to execute alternative actions if the access path fails.

The Access Path Failed view has three tabs:

• Actions tab. One of three options can be selected:

• 
  
  • Retain the source value: Use the source value when the access path fails.
  • Apply format-preserving encryption key: Encrypt the source value using the specified format-preserving encryption key.
  • Values to return: Specify the return value for each of the labels defined. For each column that was mapped to a label, a return value must be specified. If you do not provide a value, blanks will be returned for character fields and zeros will be returned for numeric fields.

• Long Data Values tab. One of two options can be selected:
  • Process as source not found; invoke access path failed: This is the default.
  • Truncate long source data value, no warning will be logged

• Logging Options tab. You can select one or both of the following logging options, but they are not required:
  • Log warning messages: When this option is selected, a warning message, including the access path failed value, will be written to the Java detail log. If this option is not selected, a count of access path failed values will be written to the Java detail log but no actual source values will be logged. When the logging option is selected, a checkbox is enabled to specify a warning threshold and a count of the maximum number of warning messages to write. When this threshold is reached, logging values will stop but access path failed values will continue to be counted. The count of values is reported on a per source field basis, so the logging threshold is applied to each field as well.
  • Execution threshold: The option to specify an Execution Threshold is provided to enable you to stop the disguise job from executing if the count of access path failed values exceeds the threshold value specified. Choose a number that is higher than the number of failures you would reasonably expect in the field.

For complete information about how to create a translate table, see Create-a-New-Translate-Table.