Data Transfer Capabilities - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2019-02-14
dita:mapPath
ybx1527114222321.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

This section covers Teradata FastLoad’s data transfer capabilities.

On network-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