Informatica Developer: Decode Function Usage
Posted by: Vittalasa Badi
An Informatica developer mapping example that demonstrates the use-cases and implementation of of the Decode function.
Overview
By design, The DECODE function in Informatica Developer searches a port for a value you specify. If the function finds the value, it returns a result value, which you define. You can build an unlimited number of searches within a DECODE function.Decode function is similar to CASE or IF? THEN? statements available in other programming languages. You can use a decode function in following cases
- Replace nested IF or IIF Statements.
- Replace lookup value looking in to small tables with constant values to improve performance.
Features
System Requirements:
- Informatica Developer 9.5.1
