What is the meaning of  Decode in Informatica?

1 answer(s) :

•   Reply
  

  Kanak

  12th Feb, 2020
  "

  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 :