What It Does - 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
When Teradata FastLoad is invoked, the utility executes the Teradata FastLoad commands and Teradata SQL statements in the Teradata FastLoad job script. These direct Teradata FastLoad to perform the following tasks:
  1. Log on to the Teradata Database for a specified number of sessions, using username, password, and tdpid/acctid information.
  2. Load the input data into the Teradata FastLoad table on the Teradata Database.
  3. Log off from the Teradata Database.
  4. If the load operation was successful, return the following information about the Teradata FastLoad operation and then terminate:
    • Total number of records read, skipped, and sent to the Teradata Database
    • Number of errors posted to the Teradata FastLoad error tables
    • Number of inserts applied
    • Number of duplicate rows