Teradata FastLoad Utility | Description | Teradata FastLoad - 17.10 - Description - FastLoad

Teradata® FastLoad Reference

Release Number
June 2021
Last Update
Content Type
Programming Reference
Publication ID
English (United States)

Teradata FastLoad is a command-driven utility which can be used to quickly load large amounts of data in an empty table on a database.

Data can be loaded from the following:
  • Disk or tape files on a mainframe-attached client system
  • Input files on a workstation-attached workstation
  • Special input module (INMOD) routines written to select, validate, and preprocess input data
  • Any other device providing properly formatted source data

Teradata FastLoad uses multiple sessions to load data. However, it loads data into only one table on a database per job. To load data into more than one table in the database, multiple Teradata FastLoad jobs must be submitted, one for each table.

Full tape support is not available for any function in Teradata FastLoad for workstation-attached client systems. To import data from a tape, write a custom access module that interfaces with the tape device. For information about how to write a custom access module, see the Teradata® Tools and Utilities Access Module Programmer Guide, B035-2424.