O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required