Half Records to one Target Half to another -- If Source is a Flat File ..

If your Source is FLAT FILE..

Design the two pipelines as shown above..

First Create a Mapping Variable $$Rec_Count

Second Pipeline

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

First Pipeline

> 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