Job Example 9: Active Directory Scan - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Objective

Periodically scan for transactional data files that continuously appear in two directories. Read the data from each new file and use it to perform updates on database tables.

For strategies on how to set up this job, see Active Directory Scan: Continuous Loading of Transactional Data and "DataConnector Operator" in Teradata® Parallel Transporter Reference, B035-2436.

Data Flow Diagram

The following figure shows a flow diagram of the elements in Job Example 9.

Job Example PTS00015 – Active Directory Scan

Sample Script

For the sample script that corresponds to this job, see the following script in the sample/userguide directory:

PTS00015: Active Directory Scan

Rationale

This job uses:
  • DataConnector operator because it is the only producer operator that can scan a directory periodically for new files and extract data from only the files that are new since the previous scan.
  • Stream operator because it is the only operator that can perform continuous updates of database tables.