31 Jan 2013
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...
03 Feb 2013
You can export the error table to see the row-content which has error.
Regards, Adeel
-- If you are stuck at something .... consider it an opportunity to think anew.
You must sign in to leave a comment.
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.