16.20 - Wizard Limitations - 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

The Wizard has the following limitations:

  • Jobs created on the Wizard can contain only a single job step.
  • The job can only perform SELECTs, INSERTs, and UPSERTs. Wizard scripts must be manually altered to perform other functions.
  • The Update and Stream operators can operate only against a single table. They only perform INSERTs, and UPSERTs.
  • A maximum of 450 columns can be defined in the source table or source record.
  • The Wizard only supports the OCI driver type 2 of the Oracle JDBC driver.