When you use the Load operator in a Teradata PT job, Teradata PT directs each parallel instance of the Load operator to do the following:
- Log in to the database, using your user name, password, database name, and account ID information specified in the job script.
- Load the input data into the Load target table on the database.
- Log off the database.
- If the Load 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 read and sent to the database
- Number of errors posted to the error tables
- Number of inserts applied
- Number of duplicate rows
- A status code indicating the success of the job
- 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.