Teradata FastLoad Utility | How It Works | Teradata FastLoad - How It Works - FastLoad

Teradata® FastLoad Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval
dita:id
wzs1478610185776
Product Category
Teradata Tools and Utilities

Teradata FastLoad processes a series of Teradata FastLoad commands and Teradata SQL statements entered either interactively or in batch mode.

Use the Teradata FastLoad commands for session control and data handling of the data transfers. The Teradata SQL statements create, maintain, and drop tables on the database.

During a load operation, Teradata FastLoad inserts the data from each record of the data source into one row of the table on a database. The table on the database receiving the data must be empty and have no defined secondary indexes.

Teradata FastLoad does not load duplicate rows from the data source to the database. (A duplicate row is one in which every field contains the exact same data as the fields of an existing row.) This is true even for MULTISET tables. To load duplicate rows in a MULTISET table, use MultiLoad.