We have a requirement to split the records into the multiple target or target files. The even and odd records are split into two targets. This scenario we uses Router Transformation to achieve.
Here we have the suppliers table with few records
Creating the two target tables.
To split the records by using the position in the source file as even and odd using Expression and Router Transformation.
In the router transformation, we have to group the records by expression and map to the target and save.
MOD (SupplierID, 2)=1 As Odd
MOD (SupplierID, 2)=0 As Even