Chapter 1 Reading Data from a Flat File and Loading it into a Teradata Table - Parallel Transporter

Teradata Parallel Transporter Quick Start Guide

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2501
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 flatfile1.txt.

ID01|JOHN
ID02|PETER
ID03|FRANK
ID04|MARY
ID05|ELLEN
ID06|MICHAEL
ID07|SAM
ID08|JONATHAN
ID09|MICHELLE
ID10|ALICE
Figure 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.