Standalone Data Load and Unload Utilities - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
jiv1600056352873.ditamap
dita:ditavalPath
jiv1600056352873.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

Teradata FastExport

Teradata FastExport extracts large quantities of data in parallel from Teradata Database to a client. The utility is the functional complement of the FastLoad and MultiLoad utilities.

Teradata FastExport can:

  • Export tables to client files.
  • Export data to an Output Modification (OUTMOD) routine. You can write an OUTMOD routine to select, validate, and preprocess exported data.
  • Perform block transfers with multisession parallelism.

Teradata FastLoad

Teradata FastLoad loads data into unpopulated tables only. Both the client and server environments support Teradata FastLoad.

Teradata FastLoad can:

  • Load data into an empty table.

    FastLoad loads data into one table per job. If you want to load data into more than one table, you can submit multiple FastLoad jobs.

  • Perform block transfers with multisession parallelism.

Teradata MultiLoad

Teradata MultiLoad supports bulk inserts, updates, and deletes against initially unpopulated or populated database tables. Both the client and server environments support Teradata MultiLoad.

Teradata MultiLoad can:

  • Run against multiple tables.
  • Perform block transfers with multisession parallelism.
  • Load data from multiple input source files.
  • Pack multiple SQL statements and associated data into a request.
  • Perform data Upserts.

Teradata Parallel Data Pump

Teradata TPump uses standard SQL (not block transfers) to maintain data in tables.

TPump also contains a resource governing method whereby you can control the use of system resources by specifying how many inserts and updates occur minute-by-minute. This allows background maintenance for insert, delete, and update operations to take place at any time of day while Teradata Database is in use.

TPump provides the following capabilities:

  • Has no limitations on the number of instances running concurrently.
  • Uses conventional row hash locking, which provides some amount of concurrent read and write access to the target tables.
  • Supports the same restart, portability, and scalability as Teradata MultiLoad.
  • Perform data Upserts.