Hi
I tryto load data oracle DB
Source Txt file
here is how data looks like with column names being A B C D and E
and datatypes being decimal decimal decimal char char respectively and dataelements defined as number(8,2) ,number 8,2 ,number8,2 ,date.tag 10,date.tag 10
and nulls allowed for last column
A B C D E
4.8 1985-01-01 100871 3.2 1985-12-31
58 1985-01-01 100890 46.4
with direct mapping in the transformer I get the following warning
exercise4..Transformer_2.DSLink4: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO PRICES(PRODID, STDPRICE, MINPRICE, STARTDATE, ENDDATE) VALUES (?,?,?,?,?)
SQLSTATE=22005, DBMS.CODE=0
[DataStage][SQL Client]Non-numeric data was found where numeric required
PRODID = 4.8
STDPRICE = 1985-01-01
MINPRICE = 100871
STARTDATE = "3.2"
ENDDATE = "1985-12-31"
How should i fix this ?
Please explain
Thanks
warnings in job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
You are trying to insert non-numeric value to a numeric filed. I suspect your mapping is not correct, see what you have passed as values for STDPRICE and STARTDATE
PRODID - number(8,2)
STDPRICE - number(8,2)
MINPRICE - number(8,2)
STARTDATE - date.tag (10)
ENDDATE - date.tag (10)
==================
PRODID = 4.8
STDPRICE = 1985-01-01
MINPRICE = 100871
STARTDATE = "3.2"
ENDDATE = "1985-12-31"
PRODID - number(8,2)
STDPRICE - number(8,2)
MINPRICE - number(8,2)
STARTDATE - date.tag (10)
ENDDATE - date.tag (10)
==================
PRODID = 4.8
STDPRICE = 1985-01-01
MINPRICE = 100871
STARTDATE = "3.2"
ENDDATE = "1985-12-31"
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>