Example: Load Job
Start Event ‑ Connecting sessions message containing a Teradata PT job ID, a Teradata PT step name, and a TDPID Step
Event message (Acquisition begins).
Step Event ‑ Checkpoint completes message.
Step Event ‑ Acquisition completes message.
Step Event ‑ Application completes message.
Step Event ‑ Rows inserted message containing the number of rows inserted into the target table.
End Event ‑ Job terminating message containing the total number of rows sent to the DBS.
Example: Update Job
Start Event ‑ Connecting sessions message containing a Teradata PT job ID, a Teradata PT step name, and a TDPID.
Step Event ‑ Checkpoint completes message.
Step Event ‑ Acquisition completes message.
Step Event ‑ Application completes message.
Step Event ‑ Rows inserted message containing the number of rows inserted into the target table (1 message per
table).
Step Event ‑ Rows updated message containing the number of rows that were updated against each of the target
tables (1 message per table).
Step Event ‑ Rows deleted message containing the number of rows that were deleted from each of the target tables
(1 message per table).
End Event ‑ Job terminating message containing the total number of rows sent to the DBS.
Example: Stream Job
Start Event ‑ Connecting sessions message containing a Teradata PT job ID, a Teradata PT step name, and a TDPID.
Step Event ‑ Loading begins message.
Step Event ‑ Loading completes message.
Step Event ‑ Rows inserted message containing the number of rows inserted into the target table (1 message per
table).
Step Event ‑ Rows updated message containing the number of rows that were updated against each of the target
tables (1 message per table).
Step Event ‑ Rows deleted message containing the number of rows that were deleted from each of the target tables
(1 message per table).
End Event ‑ Job terminating message containing the total number of rows sent to the DBS.
Example: Export Job
Start Event ‑ Connecting sessions message containing a Teradata PT job ID, a Teradata PT step name, and a TDPID.
Step Event ‑ Retrieving rows message.
End Event ‑ Job terminating message containing the total number of rows exported.