This chapter describes a third commonly used Teradata PT function: exporting data from a Teradata source table to a Teradata Target Table.
The Teradata PT script you will run exports 10 rows of employee data from a Teradata Source Table called SOURCE_EMP_TABLE, and updates a Teradata Target Table that has 10 rows of employee data.
Here are the contents of SOURCE_EMP_TABLE:
Here are the contents of the TARGET_EMP_TABLE:
ID10 ALICEFigure 3: Exporting Data from a Source Table to Loading it into a Target Table
Exporting data from a Teradata Source Table into a Teradata Target Table entails performing the following three steps. Do them in the order in which they appear here.