- Insert new rows
- Update some or all of the contents of selected existing rows
- Delete selected existing rows
Each Teradata TPump job includes a number of support commands that establish and maintain the Teradata TPump support environment, and a number of task commands that perform the actual database insert, update, or delete operations. These commands and statements identify and describe the input data to be applied to the target table, and then place that data into the target table. These activities may commence anytime after configuring the program as described in Teradata TPump Support Environment.