Data Transfer Capabilities - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
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