Overview - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide

Product
Parallel Transporter
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
asf1608578451060.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2501
lifecycle
previous
Product Category
Teradata Tools and Utilities
Starting in Teradata PT 17.00:
  • Teradata PT (script-based and Easy Loader) is only 64-bit for the following operating systems:
    • IBM AIX
    • Linux
    • macOS
    • Solaris
    • Windows
  • Teradata PT is only 32-bit for the z/OS operating system.
  • TPTAPI is only 64-bit for the following operating systems:
    • IBM AIX
    • Linux
    • macOS
    • Solaris
  • TPTAPI is still 64-bit and 32-bit for the Windows operating system.

The following topics describe the most commonly used Teradata PT function: loading flat file data into a database table.

The Teradata PT script you will run loads into the empty target table, called TARGET_EMP_TABLE, 10 rows of employee data from a flat file called flatfile1.txt whose data is delimited using the pipe (‘|’) text delimiter.

Here are the contents of flatfile1.txt.

ID01|JOHN
ID02|PETER
ID03|FRANK
ID04|MARY
ID05|ELLEN
ID06|MICHAEL
ID07|SAM
ID08|JONATHAN
ID09|MICHELLE
ID10|ALICE
Reading Data from a Flat File and Loading it into an Empty Target Table

Loading flat file data into a target table entails performing the following three steps. Do them in the order in which they appear here.