Exporting Data from a Teradata Table - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-27
dita:mapPath
uah1527114222342.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. From the Source Type list in the Job Source dialog box, select Teradata Table.
  2. In the Teradata Logon dialog box, type the host name, user ID, password, and (Optional) authentication mechanism from the drop down list to log on to your Teradata system.

    The Authentication Mechanism identifies the mechanism used for connections to the data source:

    • TD2
    • LDAP
    • KRB5
    • SPNEG0
  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.
    The Job Sourcedialog box displays the directory structure of the Teradata system you logged onto.


  5. In the left pane, select a database and a table
    to be the data source for the job.
    Do not select tables that contain character large object (CLOB) or binary large object (BLOB), JSON, or XML data types.
  6. In the right pane, select up to 450 columns to include in the source schema, or click Select All or Select None. (Press Ctrl+ click to select multiple columns.)
    If a column name from a source table is a Teradata PT reserved word, the Teradata PT Wizard appends the phrase “_#” (where # is a numeric) so that the name differs from the keyword and the submitted script does not receive a syntax error.

    For example, if the keyword DESCRIPTION is used as a column name, the name is changed to DESCRIPTION_1. Teradata PT keeps an internal counter for generating the appended number.

    For the complete list of Teradata PT reserved words, see Teradata Parallel Transporter Reference (B035-2436).

    The values under TPT Type are names of the data types associated with the Teradata PT columns. The values under DBS Type are the data types from the source database. When Teradata PT gets a column name from a source table, it looks at the definition schema of the table to determine an accurate data type. Sometimes these types can be recorded incorrectly or as a “?” when the Wizard cannot properly determine the data type. This often occurs when reading user-defined data types (UDTs).

    To change or correct a Teradata PT data type, click Edit Type (or right-click), and select the correct data type from the shortcut menu. Enter the length, precision, and scale if applicable. The precision and scale data types are only available when Decimal/Numeric is selected.

  7. Click Next to open the Job Destination dialog box.


  8. Continue with Step 3 - Select a Destination.