Posted On: Feb 22, 2018
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|
Never Miss an Articles from us.
In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..
A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales ..