Truncation of Decimal Values
Posted: Thu Jan 17, 2013 9:47 pm
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!!!!
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!!!!