Archives of the TeradataForum
Message Posted: Wed, 07 Oct 2015 @ 19:14:48 GMT
<-- Anonymously Posted: Wednesday, October 07, 2015 13:24 -->
The source field is a Char field. The data in the field has an "accented" character. It is actually an 'I' with a tick on top. When read by DataStage it is being converted and displayed as a '?' in DataStage. However, when I dumped the data in a Unix file and did an "octal-dump" on the file, it should a hex value of 032. I looked up the internet and found that it was the "substitute" (SUB) character and is being rejected by Teradata.
I suspect this is the data that is being rejected because this record gets loaded to the Teradata Error1 table and the Error1 table indicates this field as the cause of the error.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|