Sometimes the user expects errors for a part of records in a process and they are inevitable, yet this problem is known and it is preferable to ignore these failed messages and get final status of the process as SUCCESS. And in this situation failure tolerance parameter comes to aid. It determines how many failed records within a process cause the whole process FAILED.
...
| Code Block | ||
|---|---|---|
| ||
<COL TAG="W_USE_STREAM_FAILURE_TOLERANCE" EXPRESSION="'1Y'" USERDESCRIPTION="Use the preset stream Failure Tolerance value for TSR status. Y(yes(1) or N(no(0)"/> |
For Warehouse Preproc stream you can switch Failure Tolerance type between batches and separate records by setting W_FAILURE_TOLERANCE_TYPE config parameter to either BATCH or RECORD:
| Code Block | ||
|---|---|---|
| ||
<COL TAG="W_FAILURE_TOLERANCE_TYPE" EXPRESSION="'BATCH'"/> |
...