Data Quality Affects Performance - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2023-11-29
dita:mapPath
abr1608578396711.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
ogv1478610452101
Product Category
Teradata Tools and Utilities

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.