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 assurance department get their base rate increased by 1.5
So, before you begin developing your ETL, make sure you import the DimEmployee
table in the DWH datastore. We are going to use it as both source and target object in our dataflow.