rounding off of decimal digits in ORAOCI 9i stage

sb2212 · Post by **sb2212** » Fri Oct 17, 2008 3:03 am

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.

DS_SUPPORT · Post by **DS_SUPPORT** » Fri Oct 17, 2008 3:12 am

What is the data type of the column P_ID in your target, and how you have defined in your job?

sb2212 · Post by **sb2212** » Fri Oct 17, 2008 3:31 am

Its Decimal and length 60.

sachin1 · Post by **sachin1** » Fri Oct 17, 2008 3:50 am

please specify the decimal length and scale in OCI stage.

sb2212 · Post by **sb2212** » Fri Oct 17, 2008 3:59 am

The Length of P_ID in OCI stage is 38 and the data type is Decimal.There is no scale.

sachin1 · Post by **sachin1** » Fri Oct 17, 2008 4:14 am

dear you have to specify the scale if you want to have decimal values in database.

oracle oci stage ---->Inputs---->columns----you will see column name,length,scale.........etc

sb2212 · Post by **sb2212** » Fri Oct 17, 2008 4:33 am

I tried the same in oracle writing a query and inserting into the same target table.

But there I am getting currect result without specifying scale.

sb2212 · Post by **sb2212** » Fri Oct 17, 2008 5:54 am

Well using NumericRound4 in DS Transform sorts this problem.