DSXchange

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.

I tried using -A. Still the output value is 0.

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 )

The datatype in database is number. In Transformer it is decimal, lenght =38, display=40

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?

Scale? Same thing happens if you multiply by +1, yes?

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

Ill highlight Craig's suggestion, SCALE. Fix the scale.

It's not weird. You've had two people asked about the value you were using for scale - don't you think that's a big clue?

Sorry, three people.

Yes,

Sorry that I could not grab the issue in Scale. I changed my datatype in database from NUMBER to NUMBER(38,12). Now I am getting the required output.

I have a small doubt . even NUMBER should accept Decimal digits right?

NUMBER with precision will accept decimal. Without precision will just be an integer.

Please make the post Green