Error Recording | Teradata FastLoad - 17.20 - Error Recording - 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 stores the input data records related to constraint violations, conversion errors, unavailable AMP conditions, and unique primary index violations in the two error tables specified in the BEGIN LOADING command.

The following table lists error tables.

Error Tables 
Table Stores Records That Produced These Error Types
errortname1
  • Constraint violations
  • Conversion errors
  • Unavailable AMP conditions

These types of errors always occur during the loading phase of the Teradata FastLoad job after executing the BEGIN LOADING command, but before the END LOADING command.

errortname2 Unique primary index violations

This type of error always occurs during the end-loading phase of the Teradata FastLoad job after executing the END LOADING command.

Teradata FastLoad discards all records that produce a duplicate row error, but includes the total number of duplicate rows encountered, along with the total records in each error table, in the end-of-job status report.