What is the meaning of  Decode in Informatica?


Posted On: Feb 22, 2018


    1 Answer Written

  •  devquora
    Answered by Kanak

    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 RatingReturn Value
    1Very Poor

Related Questions

Please Login or Register to leave a response.

Related Questions

Informatica Interview Questions

In warehouses how many schemas are there?

There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema..

Informatica Interview Questions

Could you explain what is Enterprise data warehouse?

In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

Informatica Interview Questions

What is different between the data warehouse and data mart?

A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales..