Could anyone help me with writing case statements in Informatica PowerCenter Designer? I am fairly new to Informatica, and based on my limited experience I feel case statements aren't supported. There is a decode function with similar functionality, but I am unable to find any good examples on the syntax.
I would really appreciate if anyone could give me some specific examples on how to use case statements/decode function in Informatica.
Thanks much for your help!