DSXchange

HI Eric, Thanks for reply!! The source and target tables are oracle tables. The The source and target column datatypes unbound NUMBER. My number qualifies to fit in NUMBER datatype. There is NO truncate happening. Its the proper ROUND OFF happening which actually getting source number(decimal or non...

Hi Craig and Eric, The following are the values set at my projetc level: APT_DECIMAL_INTERM_PRECISION =38 which is default value and APT_DECIMAL_INTERM_SCALE =10 which is default value. I also tries using them at job level but it didn't work. (I used them from parameter box) I have a special req. fo...

Hi Crag ....Is is EXACTNUMERIC in uvconfig?

I havent set any scale or precision... But what i found is that even if the source number is having more than 15 digits before decimal and any number of digit after decimal, the target is having total of 15 digits(with or without precison,, Could you please let me know how to set scale or precision ...

HI Craig, I checked and found that the issue is with the precision. When I increased the precision of source number to more then 15 digits, the target number is getting round off. Could you please help?

Hi Craig,

yes its NUMBER only...NO precision on both sides.

Oracle NUMBER datatype can store a decimal number. The source is NUMBER datatype and target is also NUMBER datatype. The source value is 11111111111.489001 and in target i am getting 11111111111.489. I am using runtime column prapogation. Please let me know if I misunderstood your qestion or if you ...

Yets its NUMBER only.

Thanks Craig...The source and target tables are oracle tables. Oracle Version is 11.1.0.7. The column data type is number in source and target.

Hi I am new to data stage and i am also facing the issue.
We are using datastage runtime column prapogation for a table. The source value is 11111111111.489001 and in target getting 11111111111.489.
Decimal Places getting truncated while moving data
Could anybody pls help?

thanks