How to check which data has an error

General
Enthusiast

How to check which data has an error

I am using Fast load script to load close to 7 million records into a Teradata table. Around 1k records are getting into error table (err1). I am not able to figure out which record has erroneous value?

Can anyone share on how to approach such an situation?

Thanks.

Tags (1)
2 REPLIES
Enthusiast

Re: How to check which data has an error

err1 table is created for any translation errors or constraint violations, a row containing the wrong data type would be captured in err1 table. You need to see whether the casting of the records in err1 table is possible according to the target table data type definitions. Nomrally it happens for character to integer data type conversion but there could be data/time casting issues as well...

Teradata Employee

Re: How to check which data has an error

You can export the error table to see the row-content which has error.

Regards, Adeel