Hi Guys,
I am receiving data in Flat file. I am reading it as a Varchar and loading it to Oracle Table (Double datatype). It is loading properly (1344.324).
In an another job, when i am reading it using Oracle Connector stage (Double Datatype), i am able to see the data is coming properly as 1344.324 in View Data.
After the Oracle stage, i have a transformer stage(Double Datatype). I am routing the data to Peek Stage (Double Datatype), i am seeing the data has been truncated to 1344.32
The target table is also loaded with incorrect data 1344.32.
This is happening only with values having more than 2 decimal values.
Can somebody point me out where i am doing something wrong.
Thanks for your help in advance.
Cheers!!!!
Truncation of Decimal Values
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
Truncation of Decimal Values
Mac4rfree
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
-
- Participant
- Posts: 18
- Joined: Tue Dec 25, 2012 10:39 pm
- Location: Detroit,MI
Hi,
Please refer the below link for Datastage and Oracle Datatype considerations.
http://publib.boulder.ibm.com/infocente ... types.html
Please try using Decimal(22,10) in your transformer and let us know if this fixes your issue.
Please refer the below link for Datastage and Oracle Datatype considerations.
http://publib.boulder.ibm.com/infocente ... types.html
Please try using Decimal(22,10) in your transformer and let us know if this fixes your issue.
Harish