The Case transform allows you to put branch logic in a single location inside a dataflow in order to split the dataset and send parts of it to different locations. They might be target dataflow objects, such as tables and files, or just other transforms. The use of the Case transform simplifies ETL development and increases the readability of your code.
In this recipe, we will build the dataflow that reads the contents of the dimension table
DimEmployee and updates it according to the following business requirements: