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.