Page 1 of 1

not able to load teradata table using bulkload

Posted: Mon Sep 29, 2008 11:21 pm
by bikan
Hi,
I have job which loads the data into table using terdata bulkload stage.
jobs reads from flat file transforms the data and load it into bulkload stage. In report file I have getting following error

**** 05:44:09 FDL4831 DECIMAL type - record too short
===================================================================

I have compared metadata for table and in DS job which is exactly matching. In trasformer i am seeting @NULL to some of columns( colums are nullable). There is no warning in director log as weel as in report.

Also i am able to run the job when I replaced teradata bulk load stage with flat file.

Is this is data issue?

Thanks

Posted: Tue Sep 30, 2008 12:06 am
by hamzaqk
Check the "Generate Insert column names" option under the script tab and run the job again. should work fine.

Posted: Tue Sep 30, 2008 12:28 am
by bikan
It is already checked when I ran job