Overview | Teradata Parallel Transporter Quick Start Guide - Overview - Parallel Transporter

Teradata® Parallel Transporter Quick Start Guide - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
20.00
Published
October 2023
Language
English (United States)
Last Update
2023-11-20
dita:mapPath
msi1691132563218.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
zyr1479309207403
Product Category
Teradata Tools and Utilities

The following topics describe a third commonly used Teradata PT function: exporting data from a Teradata source table to a database target table.

The Teradata PT script you will run exports 10 rows of employee data from a source table called SOURCE_EMP_TABLE, and updates a target table that has 10 rows of employee data.

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

Here are the contents of the TARGET_EMP_TABLE:

ID01 JOHN
ID02 PETER
ID03 FRANK
ID04 MARY
ID05 ELLEN
ID06 MICHAEL
ID07 SAM
ID08 JONATHAN
ID09 MICHELLE
ID10 ALICE
Exporting Data from a Source Table to Loading it into a Target Table

Exporting data from a source table into a target table entails performing the following three steps. Do them in the order in which they appear here.