What is the meaning of  Decode in Informatica?

  • Sharad Jaiswal
  • 22nd Feb, 2018

1 answer(s) :

  •   Reply
    img

    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 :

Valid name is required.

Valid name is required.

Valid email id is required.