DSXchange

I am trying to pull data off of a db2 database and load it into teradata via the terabulk process. My problem is that some of the fields coming off of db2 are defined decimal(16,0) and the actual value in some rows is 0.00. The Bulk loader is giving me the following error...

Precision value for column SRC_TOT_AM in stage OneTimeLoadMWBLoadAdPlan.Terabulk_13 must be 1-9

Does anyone have any suggestions on how to resolve this error.

It works fine if I use the regular odbc stage and load it that way. Problem is there are way to many rows(90,000) to load this way.

Thanks,
Marc

Try lying in yout column definition metadata for the link that writes to the bulk loader. At worst you'll get ONE metadata mismatch warning, but the job will go on.