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.