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.