Job Example 21: Bulk Delete of Data from a Teradata Database
Job Objective
Delete data from a Teradata Database table.
Data Flow Diagram
Figure 47 shows a diagram of the job elements for Job Example 17.
Figure 47: Job Example PTS00024 -- Delete Data from a Teradata Database TableSample Script
For the sample script that corresponds to this job, ee 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.