Using Teradata PT Easy Loader - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

Teradata PT Easy Loader is a command-line interface for loading data from database tables without requiring you to write a Teradata PT script.

Example 1

To load data from database tables, you can specify all job options that describe the data source in a job variables file, as follows:

SourceTdpId  = 'TdpId',
SourceUserName  = 'username',
SourceUserPassword = 'userpassword',
SelectStmt = 'Teradata SQL SELECT statement'
Rather than specifying in a SELECT statement in the job variables file, you can specify the table name of the source table, as follows:
SourceTable = 'tablename'

Then execute the following command:

tdload -t  tablename  -u  username  -j  jobvariablesfile

Example 2

To load data from database tables, you can specify all job options that describe the data source as well as the target table in the job variable files, as follows:

TargetTable = 'tablename',
TargetTdpId  = 'TdpId',
TargetUserName  = 'username',
TargetUserPassword = 'userpassword',
SourceTdpId  = 'TdpId',
SourceUserName  = 'username',
SourceUserPassword = 'userpassword',
SelectStmt = 'Teradata SQL SELECT statement'

Then execute the following command:

tdload -j  jobvariablesfile

For information on defining a job variables file and on executing the tdload command, see Teradata PT Easy Loader.