Case transform is a part of Platform set of Transform in data services. It deals with the branching logic i.e it separates source data into multiple output data sets based on a condition.
For example, the source data from different countries is diverted to separate country tables based on certain conditions.
The condition based on which the data is branched has two parts: Label and Expression.
The label is the path name to the target table and the expression has the SQL logic that separates the data.
For example, define a label Region_INDIA where expression is Employee.regionId = 1.
Here, Employee is the source table having regionId as a column.
To understand it more clearly, login to the data services. Create some sample data in Microsoft SQL Server like below: Continue reading →