Allowable Errors
The Stream operator definition can employ the ErrorLimit attribute to specify the approximate number of records that can be stored in the error table before the Stream operator job is terminated. This number is approximate because the Stream operator sends multiple rows of data simultaneously to the Teradata Database. By the time Teradata PT processes the message indicating that the error limit has been exceeded, it may have loaded more records into the error table than the number specified in the error limit.
When the Stream operator encounters a data row that cannot be processed properly, it creates a row in the error table. Such errors are added to the error table until it reaches the limit. Specify these options in the APPLY statement, immediately following the DML statements to which they apply, to control error handling for those DML statements by the Stream operator.
Note: The application of the error limit may apply either per operator instance or per operator depending on the stage of the load task when the limit is reached. For details, see “Effects of Error Limits” on page 164.
Strategy
Consider the following when setting the ErrorLimit value:
For a detailed description and required syntax the chapter on Stream operator in Teradata Parallel Transporter Reference.