not able to load teradata table using bulkload

bikan · Post by **bikan** » Mon Sep 29, 2008 11:21 pm

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

hamzaqk · Post by **hamzaqk** » Tue Sep 30, 2008 12:06 am

Check the "Generate Insert column names" option under the script tab and run the job again. should work fine.

bikan · Post by **bikan** » Tue Sep 30, 2008 12:28 am

It is already checked when I ran job