Launch a Teradata PT Easy Loader Job - Parallel Transporter

Example 1: Loading Data from a File to a Teradata Table

tdload -h 8.8.8.8 -u User1 -p Pass1 -f DATA.txt -t MyTable MyJob

The above command will use '8.8.8.8' as the IP address of the machine on which the database is installed, log on to the account 'User1' with the password 'Pass1' and load data from the file DATA.txt into the table 'MyTable'. The job is named "MyJob" for easy logging.

Example 2: Unloading Data from a Teradata Table into a Flat File

tdload  --SourceTdpid 8.8.8.8 --SourceUserName User1
		--SourceUserPassword Pass1 --SourceTable MyTable
		--TargetFilename outfile.txt My_Unload_Job

The above command will use '8.8.8.8' as the IP address of the machine on which the database is installed, log on to the account 'User1' with the password 'Pass1', the Unload data from table 'MyTable' into the file 'outfile.txt'. It will also name the job 'My_Unload_Job' for easy Log access

Example 3: Loading Data from one Teradata Table to Another

tdload  --SourceTdpid 8.8.8.8 --SourceUserName User1
		--SourceUserPassword Pass1 --SourceTable MyOutTable
		--TargetTdpid 4.4.4.4 --TargetUserName User2
		--TargetUserPassword Pass2 --TargetTable MyInTable

The above command will use '8.8.8.8' and '4.4.4.4' as the IP addresses of the machines on which the databases are installed, '8.8.8.8' as the source machine and '4.4.4.4' as the target. Log on to the accounts 'User1' and 'User2' with passwords 'Pass1' and 'Pass2' respectively, then Unload data from table 'MyOutTable' into table 'MyInTable’.

Example 4: Loading Data from a Flat File into a Teradata Table, Choosing the Consumer Operator

tdload -f emp_data.txt -u dbadmin -p pw123 -h tdat1 -t employee 
       -d “|” –-UpdateTraceLevel All

The above command will use ‘tdat1’ as the TdpId of the machine on which the database is installed, log on to the account ‘dbadmin’ with the password 'pw123' and load data from the file emp_data.txt into the table 'employee'. Because we have specified “--UpdateTraceLevel All” as an job variable, tdload will attempt to use the Update operator as the consumer, and resolve all defaults to match it.

Example 5: Loading Data from a Teradata Table into Another Teradata Table

tdload  --SourceTdpid OldDataBase --SourceUserName User1
		--SourceUserPassword Pass1 --SourceTable MyOutTable
		--TargetTdpid NewDataBase --TargetUserName User2
		--TargetUserPassword Pass2 --TargetTable MyInTable
		--ExportPrivateLogName ExportLog --LoadTraceLevel All

The above command will use 'OldDataBase' and 'NewDatabase' as the TdpIds of the machines on which the databases are installed, where 'OldDataBase' is the source machine and 'NewDataBase' is the target machine.

Easy Loader will log on to the accounts 'User1' and 'User2' with passwords 'Pass1' and 'Pass2' respectively, then unload data from table 'MyOutTable' into table 'MyInTable’.

Because “--ExportPrivateLogName ExportLog” and “--LoadTraceLevel All” are defined, tdload will attempt to use Export as the producer operator and Load as the consumer operator. This job will fail if the target table does not meet the characteristics required by the Load operator.

Example 6: Using a Job Variable File with tdload

tdload -j my_jvfile My_JVF_Job

with the contents of my_jvfile as:

h = '8.8.8.8',                                                  
u = 'User1',                                                    
p = 'Pass1',                                                    
f = 'DATA.txt',                                                 
t = 'MyTable',                                                  
TargetMaxSessions = 8 

The above command and job variable file will perform the same operation as example #1, as well as set the consumer operator’s MaxSessions job variable to 8 and name the job 'My_JVF_Job'.

Example 7: Loading Data from a File to a Default Teradata Staging Table

tdload -h 8.8.8.8 -u User1 -p Pass1 -f DATA.txt -t MyTable --DefaultStagingTable MyJob

The above command will use '8.8.8.8' as the IP address of the machine on which the database is installed, log on to the account 'User1' with the password 'Pass1' and load data from the file DATA.txt into the default staging table 'MyTable_STG'. The job is named "MyJob" for easy logging. TPT Easy Loader will create the staging table

Example 8: Loading Data from a File to a User-specified Teradata Staging Table

tdload -h 8.8.8.8 -u User1 -p Pass1 -f DATA.txt -t MyTable --StagingTable MyStagingTable MyJob

The above command will use '8.8.8.8' as the IP address of the machine on which the database is installed, log on to the account 'User1' with the password 'Pass1', and load data from the file DATA.txt into the staging table 'MyStagingTable'. The job is named "MyJob" for easy logging. TPT Easy Loader will create the staging table.