This chapter describes the second most commonly used Teradata PT function: exporting data from a Teradata Table to a flat file.
The Teradata PT script you will run exports 10 rows of employee data from a Teradata
table called SOURCE_EMP_TABLE, and writes the rows to a flat file called
flatfile2.txt whose data will be delimited using a comma (‘,’) text delimiter.
Here are the contents of
ID20 MONICAFigure 2: Exporting Data from a Teradata Source Table and Writing it to a Flat File
Exporting data from a Teradata Source Table into a flat file entails performing the following three steps. Do them in the order in which they appear here.