The Stream Operator Function in a Teradata PT Script - Parallel Transporter

The Stream Operator Function in a Teradata PT Script

When you use the Stream operator in a Teradata PT job, the Stream operator:

1 Logs on to the Teradata Database, using your user name, password, Teradata Database, and account ID information specified in the job script.

2 Loads the data from the Teradata PT data streams into the Teradata Database.

3 Logs off from the Teradata Database

4 If the Stream operator job is successful, terminate the job and provide information about the job in the log or to the user, such as:

Total number of records sent to the Teradata Database

Number of errors posted to the error table

Number of Inserts, Updates, and Deletes applied

5 If the job is unsuccessful, terminate the job and provide information about the job so that you can correct any problem and restart the job.