Hi all,
In my target table,I've a column P_ID which is given by Measure/Rate,Measure and Rate coming from the source table.
The value getting into P_ID after the division is getting rounded off. For Eg., If the actual value after the division is 122.91,P_ID will get populated as 123, If the value is 0.7,P_ID gets 1.
I want to load P_ID with the actual values i.e,122.91,0.7 etc and not the rounded value.
Could anyone suggest any y this is happeneing and any possible solution.
I am using server edition 6.0 and the target is a ORAOCI9i stage.
There is no warning or error as such.
Thanks.
rounding off of decimal digits in ORAOCI 9i stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 232
- Joined: Fri Aug 04, 2006 1:20 am
- Location: Bangalore