Job Example 6: Loading Data from Other Relational Databases - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

Job Objective

Read data from an ODBC-compliant relational databases such as Oracle, SQL Server, DB2, and so forth, and write it to database tables.

Data Flow Diagram

The following diagram shows a diagram of the job elements for Job Example 6.

Job Example PTS00012 – Loading Data from Other Relational Databases

Sample Script

For the sample script that corresponds to this job, see the following scripts in the sample/userguide directory:
  • PTS00012A: Loading Data from Other Relational Databases into an Empty Teradata Database Table
  • PTS00012B: Scalable Loading of an ODBC Table into an Empty Teradata Database Table

Rationale

The job uses:
  • ODBC operator because it is the only operator that can read data from ODBC-compliant external databases.
  • Load operator because it offers the best performance for high-speed writing of a large number of rows into empty database tables.