Loading Data to a Teradata Table - Parallel Transporter

Teradata® Parallel Transporter User Guide

Parallel Transporter
Release Number
August 2020
English (United States)
Last Update
Product Category
Teradata Tools and Utilities
  1. In Destination Type of the Job Destination dialog box, select Teradata Table.
  2. In the Teradata Logon dialog box, type the host name, user ID, and password to log onto the target Teradata system.

  3. (Optional) Select the check boxes to include your user ID and password in the generated scripts. The default is to enter placeholders. Select the Enable Logon Encryption check box to enable encryption of login information passed to the database. By default, logon encryption is disabled.
  4. Click OK to close the log on prompt and return to the Job Destination dialog box. For more information, see Step 2 - Select a Source and Select Data.

    The directory structure and columns of the Teradata system are displayed. (The values are not editable.)

  5. (Optional) In Number of Instances, type a number to designate the number of consumer operator instances to process at the same time.
  6. Click Next to open the Operator Type Selection dialog box.

  7. Select one of the following options depending on what Teradata PT operator or operation is to be used for the job. For more information about operators, see the Teradata Parallel Transporter Reference (B035-2436).
    • Load Operator – Use this option only if the destination table is empty; the job fails if it is not empty. This option transfers data much faster than the Update or Stream operators.
    • Stream Operator – Use this option to update a destination table from a source that generates constant data. Selecting this option requires an additional selection of an insert or upsert operation.
    • Insert Operation– Use this option to copy data from the source to the destination.
    • Upsert Operation– Selecting this option opens the Update Row Specification dialog box.