What is the meaning of Decode in Informatica?

devquora

devquora

Posted On: Feb 22, 2018

1 Answer Written

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 Rating Return Value
1 Very Poor
2 Bad
3 Ok
4 Good
5 Awesome

Related Questions

Please Login or Register to leave a response.

Never Miss an Articles from us.

Related 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 ..

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..

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 ..