Splitting the flow of data with the Case transform

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.

Getting ready

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:

  • All male employees in the production department gets extra vacation hours
  • All female employees in the production department get 10 extra sick hours
  • All employees in the quality ...

Get SAP Data Services 4.x Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.