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
Teradata Bulk Loader question
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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. 
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.