16.10 - Data Quality Affects Performance - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

It is more important to have error-free data when using the Stream operator than with other Teradata PT operators. If data contains errors, a large Pack factor can slow performance because of the way Stream handles errors.

For example, if the statement independence feature is not used and several hundred statements are packed, the entire request (when an error occurs) is rolled back. The Stream operator then removes the error-producing statement and reissues the entire request. Such a process can be costly from a performance standpoint.

If the statement independence feature is used and several hundred statements are packed, the entire request (when an error occurs) will not be rolled back or reissued. The error will be inserted into the Stream operator’s error table if the errors are marked. The statement independence feature can improve performance.

Statement independence feature only supports the INSERT statement. No other DML statements are supported.