How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let’s see how do it in SSIS and the very same thing can be achieved in ADF.

Problem statement

For my simple scenario, when the PortfolioTypeCode has a value of either ‘Mutual Fund’ or ‘Pooled Fund’, my package should return a 1, otherwise it should return 0.

In SSIS, under data flow you will have an OLEDB source, like shown below in Fig 1.