Data Transfer Capabilities | Teradata FastLoad - 17.10 - Data Transfer Capabilities - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

This section covers Teradata FastLoad’s data transfer capabilities.

On workstation-attached workstations, Teradata FastLoad uses the TCP/IP network protocol for all data transfer operations.

On mainframe-attached systems, Teradata FastLoad transfers data as either:
  • A multi-volume data set or file
  • A number of single-volume data sets or files in separate Teradata FastLoad jobs

Serial Teradata FastLoad operations can be restarted by loading the next tape in a series instead of beginning with the first tape in a set.

In either case, Teradata FastLoad does one of the following:
  • Uses multiple Teradata sessions, at one session per AMP, to transfer data
  • Transfers multiple rows of data within a single message
Also, in either case, until the Teradata FastLoad job is completed and the data loaded into the Teradata FastLoad table:
  • There is no journaling or fallback data
  • The secondary indexes cannot be defined