Multiplication with -1 in Transformer
Moderators: chulett, rschirm, roy
Multiplication with -1 in Transformer
I have a i/p link variable A in transformer and I doing a derivation
as A*-1. (i.e i need to negate the vaue of A)
When value of A is 0.00999, A*-1 is giving result as 0. Whereas only A is giving , it is giving 0.00999.
Why am I getting a value of 0 when it is multipled by -1.
Any solution for this.
as A*-1. (i.e i need to negate the vaue of A)
When value of A is 0.00999, A*-1 is giving result as 0. Whereas only A is giving , it is giving 0.00999.
Why am I getting a value of 0 when it is multipled by -1.
Any solution for this.
Aim high
nkln@you
Can you please tell us what is the Data Type you have been using for the derivation(Target).
If you have you the appropriate data type then you should get the -ve value
I believe you are using an inappropriate data type so the solution is becoming as 0 (no precision added )
Can you please tell us what is the Data Type you have been using for the derivation(Target).
If you have you the appropriate data type then you should get the -ve value
I believe you are using an inappropriate data type so the solution is becoming as 0 (no precision added )
Regards,
Shree
785-816-0728
Shree
785-816-0728
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What data type are you using in DataStage? This behaviour might occur, for example, if you were using an unsigned numeric or an inappropriate scale value. Are any warnings logged?
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.
Ray,
The datatype in Datastage is decimal whose lenght is 38 , display is 40, no value for scale. There are no errors or warnings in logs.
Chulett,
Yes, Chullet even when I multiplied with +1 it is giving a value of 0. Only when it is directly mapped, I am getting original values. This is wierd.
What's wrong with my code
The datatype in Datastage is decimal whose lenght is 38 , display is 40, no value for scale. There are no errors or warnings in logs.
Chulett,
Yes, Chullet even when I multiplied with +1 it is giving a value of 0. Only when it is directly mapped, I am getting original values. This is wierd.
What's wrong with my code
Aim high