This chapter describes the most commonly used Teradata PT function: loading flat file data into a Teradata 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
ID10|ALICEFigure 1: 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.