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