Is there any negation operator in Informatica, which could be used in the following scenario.
My requirement is that if the value of a variable is say -5 then make it as +5.
Using the 'SIGN' operator I would be able to identify if it is '-5'.
How to implement the next part, if it is '-5' then make it as '+5'?
TIA
My requirement is that if the value of a variable is say -5 then make it as +5.
Using the 'SIGN' operator I would be able to identify if it is '-5'.
How to implement the next part, if it is '-5' then make it as '+5'?
TIA