Error Tables and Error Reporting
Duplicate Records
The Teradata Database ignores duplicate records and they are not inserted in either error table.
Reusing Table Names
Error tables with one or more rows are not dropped from the Teradata Database at the end of a Load driver job. To reuse the names specified for the error tables, use the DROP TABLE statement from BTEQ to remove the tables from the Teradata Database.