Data Quality Affects Performance
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.