How to turn off rounding in a PX job?
Moderators: chulett, rschirm, roy
How to turn off rounding in a PX job?
Hi, anyone know how to disable rounding in a PX job for decimal fields?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
Re: How to turn off rounding in a PX job?
HI Can you please explain me what do u mean by rounding the px job,
is it any particular field are yoy talking about??
Ray said using Floor function
too my knowledge it is used for a prticular field
please lemme know
thanks
is it any particular field are yoy talking about??
Ray said using Floor function
too my knowledge it is used for a prticular field
please lemme know
thanks
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
Based on my experience Datastage based on precision and scale will try to round decimal fields when doing logic or calculations within a transformer.
For String to Decimal
StringToDecimal(inputvalues,'floor') works but not work for expo values. However I avoid this issue because I'm not dealing with expo values in this scenario.
We are using decimal to decimal and it seems to be working.
DecimalToDecimal(inputvalues,'floor')
For String to Decimal
StringToDecimal(inputvalues,'floor') works but not work for expo values. However I avoid this issue because I'm not dealing with expo values in this scenario.
We are using decimal to decimal and it seems to be working.
DecimalToDecimal(inputvalues,'floor')