Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Q on Negation operator in Informatica

Status
Not open for further replies.

OraBalz

Programmer
Mar 3, 2004
9
0
0
IN
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
 
if it's always going to be positive, use ABS(value). If you want to switch it's value, use -1*value. or just -value.

"I think we're all Bozos on this bus!" - Firesign Theatre [jester]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top