Correcting Errors | Teradata FastLoad - 17.00 - Correcting Errors - 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
Though the procedures are somewhat different, depending on the error table, correcting errors is a three-step process:
  1. The error information is retrieved from the error tables on the database.
  2. Errors are evaluated and corrected.
  3. Corrected records are inserted into the Teradata FastLoad table.

After the job has completed, another utility, such as BTEQ, must be used to access the database, because Teradata FastLoad only operates on an empty table. The procedures and examples in the following subsections are performed under BTEQ. They assume BTEQ has been invoked and logged on to the database. For more information about using BTEQ, see Basic Teradata® Query Reference, B035-2414.