Configuring Data Transform Error Handling Policy at Classifier Level

Note: You need to perform this procedure only if you want to define a policy that is different from the policy defined at the transformation level.

To configure an error handling policy at the classifier level, do the following steps:

  1. From the Transformation View, select the transformation, and then select the connection between the desired classifiers.

  2. In the Properties pane on the right, under Data Transform Error Handling Policy, select one of the following options from the list:

    Note: The options available are <Inherit> and either Stop or TruncateOrReject based on the option chosen at transformation level. For example, if the option chosen is Stop, then the options available in the Properties pane are <Inherit> and TruncateOrReject.

    • <Inherit>: To inherit the policy defined at the transformation level.

      For example, if you have set the policy at the transformation level to Stop, then the policy at the classifier level also becomes Stop when you select <Inherit>.

    • Stop: To stop the Runtime Service when there is any data conversion, filter, or DML command substitution error.

    • TruncateOrReject: To truncate or reject the source value depending on the data type and size of the target column. If the Runtime Service cannot successfully truncate the source value, then the value is rejected.

      Refer to the example provided in the Configuring Data Transform Error Handling Policy at Transformation Level topic for details.

  3. Click OK.