Job Example 15: Export Data from a Table and Load It into an Empty Table - Parallel Transporter

Teradata Parallel Transporter User Guide

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

Job Example 15: Export Data from a Table and Load It into an Empty Table

Job Objective

Export data from Teradata Database staging tables before loading it into an empty production table in either the same or a different Teradata Database.

Data Flow Diagram

Figure 45 shows a diagram of the job elements for Job Example 15.

Figure 45: Job Example PTS00022 -- Exporting Data and Loading It into Production Tables

Sample Script

For the sample script that corresponds to this job, see the following script in the sample/userguide directory:

PTS00022: Extracting Data from a Teradata Database Staging Table and Loading It into a Production Table.

Rationale

This job uses:

  • DDL operator because it can DROP work tables and CREATE new target tables prior to loading.
  • Export operator because it can extract large amounts of data from a Teradata Database table at high speed.
  • Note: The SQL operator extracts data more slowly than the Export operator. However, the SQL Selector operator can be used if the Teradata Database is short on load slots, because SQL Selector operator instances are not counted as using load slots.

  • Use Load operator because it can load large amounts of data into an empty Teradata Database table at high speed.