Load Operator Errors
The Teradata Database tracks and records information about various types of error conditions that cause an input data record to be rejected during a load operation. The following error conditions can occur:
Error Condition |
Cause of Rejection |
Constraint violation |
Records do not comply with the range constraints you defined when creating the table. |
Unavailable AMP condition |
Records are destined for a nonfallback table on an AMP that is down. |
Data conversion errors |
Refers to records from the input file that fail a specific data type conversion. |
Unique primary index violation |
Records contain a value for the unique primary index field that already exists, but is not a duplicate row. |
Duplicate row |
Records are exact duplicates of existing rows. |