15.10 - Task 2: Launch a Teradata PT Easy Loader Job - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

Task 2: Launch a Teradata PT Easy Loader Job

Procedure

Follow these steps to launch a Teradata PT Easy Loader job.

1 In a Command window, navigate to the directory where your data file is stored.

2 Enter the tdload command at the command prompt. For example:

tdload -f filename -u username -p password -h tdpid -t tablename

3 The screen will display the Job Id for the load job.

Example  

The following tdload command loads data from the emp_data.txt file into the Tables_Database.Employee table. The name of the load job is EmpLoadJob.

tdload -f emp_data.txt -u dbadmin -p pw123 -h tdat1 -t employee -d ''|'' --TargetWorkingDatabase Tables_Database EmpLoadJob

Example  

The following example uses the empload_jobvars job variables file that this example assumes has specified all job options associated with the Teradata PT Easy Loader job in Example 1 above. Using the -j option eliminates the need to type the options when executing tdload.

tdload -j empload_jobvars.txt

Sample Flat File

The following shows the contents of a flat file with data in delimited format. The delimiter character is the pipe(''|''). Teradata PT Easy Loader can only load a delimited format flat file.

The schema of this file matches the schema of the Teradata Employee table used in the other Teradata PT job examples.

10001|John Smith|93000.00|1954-10-21|Sr. Software Engineer|100|Y|5
10002|Mary Knotts|45000.00|1974-09-13|Secretary|100|Y|1
10005|Keith Muller|85000.00|1972-06-09|Sr. Software Engineer|100|Y|3
10021|David Crane|65000.00|1966-10-02|Technical Writer|101|Y|2
10022|Richard Dublin|60000.00|1965-03-19|Software Engineer|100|N|0
10023|Kelly 0'Toole|65000.00|1955-04-08|Software Tester|102|N|2
10024|Brett Jackson|75000.00|1962-04-08|Software Engineer|100|Y|2
10025|Erik Wickman|79000.00|1965-03-08|Software Engineer|100|N|2