Job Example 5: Continuous Loading of Transactional Data from JMS or MQ
Job Objective
Read transactional data from MQ or JMS and perform continuous INSERT, UPDATE, and DELETE operations on one or more Teradata Database tables and optionally load an external flat file with the same data, using the Teradata PT duplicate data stream feature. In this job the Stream operation functions like the Teradata standalone utility TPump.
Data Flow Diagram
Figure 27 through Figure 29 show diagrams of the job elements for variations of Job Example 5.
Figure 27: Job Example PTS00009 -- Read Transactional Data from JMS and Load Using the Stream Operator
Figure 28: Job Example PTS00010 -- Read Transactional Data from MQ and Load Using the Stream
Operator
Figure 29: Job Example PTS00011 -- Read Transactional Data from JMS or MQ Simultaneously and
Load the Data to a Teradata Database and a Backup File
Sample Scripts
For the sample scripts that correspond to the three variations of this job, see the following scripts in the sample/userguide directory:
Rationale
This job uses: