Hi All,
Does Datastage recognise exponential numbers?
ie., incoming data is 9.9999999999999995e-07
and we want to recognise this in datastage and then do validation on this.
any advise or help would be appreciable
Exponential number conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 104
- Joined: Sat Dec 24, 2005 1:26 am
- Location: Bengaluru
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Precision can also be an issue; there are precision limits on decimal number. In your example you will be introducing a requirement for an additional seven digits of precision (since you are multiplying by 10**-7); does your output field data type cater for that?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.