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!
You're right - there is no
CASE
statement, but you can useDECODE
to simulate it:It is an equivalent of the following Transact-SQL
CASE
statement:Here's how it works:
TRUE
value,Look also at the IIF() function which is often used to implement conditional logic: