Teradata FastLoad Utility | How It Works | Teradata FastLoad - 17.10 - How It Works - 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)

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.