Loading Data to 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. 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.


    Use this option to select the destination columns that will get updated with data values from the source. Only the data values in the destination table that match the data values in the source are updated. When data does not match, a new row is created.

    At least one column must be selected, and at least one column must remain cleared.
  8. Click Next to open the Map Source to Destination dialog box.


  9. Click the Automatic Mapping button to map the first source column to the first destination column, the second source column to the second destination column, and so on.
    • If the number of columns in Source is not the same as the number of columns in Destination, Teradata PT warns that it cannot map source columns to destination columns automatically and prompts you to map source and destination columns manually.


      To map a source to a destination column manually, click a row in Source to open its drop-down list. Then select a data value for that source column row to map to a destination column. Note that one source column value can be mapped to multiple destination columns. Moreover, source columns can be left as Column Not Mapped as long as at least one column in the table is mapped.

    • If the data types of the mapped columns are not the same, Teradata PT indicates that it cannot map source and destination columns and asks you to correct the mismatched data types.




    • If you click YES, Teradata PT returns to the Map Source to Destination screen so you can map source to destination columns manually.

      To map a source to a destination column manually, click a row in Source to open its drop-down list. Then select a data value for that source column row to map to a destination column. One source column value can be mapped to multiple destination columns. Moreover, source columns can be left as Column Not Mapped as long as at least one column in the table is mapped.

    • If you click NO, Teradata PT ignores the mismatched data types between columns and proceeds to map source and destination columns.

      There are cases when the data types of the source and destination columns do not match, but the database can implicitly convert source column data types to destination column data types. For example, when the source column data type is smallint and the destination column data type is integer, the database can convert the source column data type to the destination column data type.

    To clear automatic mapping, click the Clear Mapping button. When you do, all automatic mapping is cleared and the Clear Mapping button is disabled. (That button is only enabled after the Automatic Mapping button is clicked.)

    Once you have cleared automatic mapping, you can re-map source and destination columns automatically (by clicking the Automatic Mapping button) or manually (by clicking a row in Source to open its drop-down list and selecting a data value for that source column row to map to a destination column).

  10. Click Next to open the Finish Job dialog box.


  11. Continue with Step 4 - Run the Job.