Job Example 21: Bulk Delete of Data from a Teradata Database - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-09
dita:mapPath
vyv1488824663502.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Objective

Delete data from a Teradata Database table.

Data Flow Diagram

The following figure shows a diagram of the job elements for Job Example 21.

Job Example PTS00024 – Delete Data from a Teradata Database Table

Sample Script

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

PTS00024: Bulk Delete of Data from a Teradata Database.

Rationale

The job uses the Update operator because it is the only operator that can do stand alone bulk delete of data in a Teradata Database table.