The following topics describe the second most commonly used Teradata PT function: exporting data from a database table to a flat file.
The Teradata PT script you will run exports 10 rows of employee data from a database table called SOURCE_EMP_TABLE, and writes the rows to a flat file called flatfile2.dat whose data will be delimited using a comma (‘,’) text delimiter.
Here are the contents of SOURCE_EMP_TABLE.
ID11 BILLY ID12 JANIE ID13 KRYSTAL ID14 MATTHEW ID15 LINDA ID16 DAN ID17 LAINE ID18 MICHIKO ID19 WILL ID20 MONICA
Exporting Data from a Database Source Table and Writing it to a Flat File
Exporting data from a database source table into a flat file entails performing the following three steps. Do them in the order in which they appear here.