What is the meaning of Decode in Informatica?
- Sharad Jaiswal
- 22nd Feb, 2018
1 answer(s) :
-
Reply
"
Decode in Informatica
In the world of Informatica, we use the application of traditional CASE or IF which is possible by the decode in Informatica. It is one of the most helpful statements for different conditions. For defining an output port or variable we need to use this expression transformation known as decode. To transform the heavy mappings we require to leverage this function.
An example to understand the decode in Informatica.
Example: To search for the exact value and matching the result, decode in Informatica is used.
DECODE(StarRating, 1,'Very Poor', 2,'Bad', 3,'OK', 4,'Good', 5,'Awesome!', 'OK')
Star Rating Return Value 1 Very Poor 2 Bad 3 Ok 4 Good 5 Awesome
Post your Answer :
Valid name is required.
Valid name is required.
Valid email id is required.
Kanak
12th Feb, 2020