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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.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.