Job Example 6: Loading Data from Other Relational Databases
Job Objective:
Read data from an ODBC-compliant relational databases such as Oracle, SQL Server, DB2, and so forth, and write it to Teradata Database tables.
Data Flow Diagram
Figure 30 shows a diagram of the job elements for Job Example 6.
Figure 30: Job Example PTS00012 -- Loading Data from Other Relational DatabasesSample Script
For the sample script that corresponds to this job, ee 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: