Intermediate File Logging
An Intermediate File Logging job reads transactional data from MQ or JMS and performs continuous INSERT, UPDATE, and DELETE operations in a Teradata Database table, while simultaneously loading a duplicate data stream into an external flat file that can serve as an archive or backup file of the data that has been loaded.
Strategy
Intermediate File Logging requires use of multiple APPLY clauses, one for the operator writing to Teradata Database and one for the operator writing to the external flat file.
The DataConnector operator is used twice in the job script:
Note that the two DataConnector operator definitions differ in content, in addition to the common required attributes:
For a complete list of key DataConnector operator attributes Teradata Parallel Transporter Reference.
For a typical application of Intermediate File Logging Example 5C in “Job Example 5: Continuous Loading of Transactional Data from JMS or MQ” on page 108.
For the sample script that corresponds to this job, ee the following script in the sample/userguide directory
PTS00011: Intermediate File Logging Using Multiple APPLY Clauses with Continuous Loading of Transactional Data from Different Access Modules.