If your Source is FLAT FILE..
Design the two pipelines as shown above..
First Create a Mapping Variable $$Rec_Count
> Idea is to pick up Count of Rows using Aggrigator transformation using COUNT() function..... CNT = COUNT(*)
> Using Exp-Tr that value will be assigned to Mapping variable using SETVARIABL($$Rec_Count, CNT)
> Filter Tr is used with conditon set as FALSE.. becoz no records need to be loaded into target.
Here our idea is to find out RowCount and assigingin it to Mapping variable only..
> In the Exp-Tr create a new port Rec_count (variable port) and increment it with 1 -- Rec_count + 1
This is becz inorder to generate seqnum with out using Seq-Gen-Tr ...
> Create o/p port O_Rec_count = Rec_count
> Pass all ports to Router .. Create a group and conditon as
Rec_Count <= ($$Rec_Count / 2)
Here $$Rec_Count is mapping variable.....
> Connect respective groups to targets.. mean default group to second target..
NOTE : In this example Second pipeline should execute first so set ..
Target Load Order : Second Pipeline first -- First Pipeline next