Starting in Teradata PT 17.00:
- Teradata PT (script-based and Easy Loader and TPT API) 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.
- Starting in 17.20, 32-bit TPTAPI is no longer supported 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.