Error loading Teradata Decimal column

wfis · Post by **wfis** » Mon Mar 03, 2008 3:21 am

Hi,
I'm trying to load a teradata table using Enterprise stage.Source is a dataset. Mode Write Truncate.
While loading, the job aborts due to Datatype mismatch for column A, where col A is Decimal[20,0] both in source dataset as well as in Teradata target table.
I read around some forums that Teradata has problem in handling decimal fields greater than len 18. So i reduced the target field length to 18 in Enterprise stage. The job runs but throws numerous warnings for 'possible truncation.value is too large for destination field.

Interesting part is, there are sample records in the table and when i dumped them in a dataset and tried loading the same recs into table, i got the same type mismatch error.
Any help will be greatly appreciated.
Thanks.

hamzaqk · Post by **hamzaqk** » Mon Mar 03, 2008 4:58 am

i would take your source is oracle ?

wfis · Post by **wfis** » Mon Mar 03, 2008 6:06 am

hamzaqk wrote:i would take your source is oracle ?

Well, its a flat file being sourced from Mainframe DB2.

-thnx