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

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.