15.10 - Example: Load Job - Parallel Transporter

Teradata Parallel Transporter User Guide

prodname
Parallel Transporter
vrm_release
15.10
category
User Guide
featnum
B035-2445-035K

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.