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

Teradata® FastLoad Reference - 17.20

Product
FastLoad
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-10-11
dita:mapPath
dlf1641281592734.ditamap
dita:ditavalPath
vax1619194969834.ditaval

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.