How to load first,last,remaining records into different targets when source is a flat file?

Scenario:

How to load first,last,remaining records into different targets when source is a flat file?

Solution: 

If you are using seq and aggregator then the mapping flow should be like below

                              -->AGG
SRC-->SQ-->EXP                  -->JNR-->RTR-->TGT1
         SEQ-->                                            -->TGT2
                                                                -->TGT3

In router if seq value =1 then that record will go to target1
if seq value and agg count out put equal that means that is last record so it has to go to target 3
the remaining all records has to pass to target 2.

for sql query to get first, last and remaining records try the below

For First record:
select * from emp where rownum=1;

For Last record:
select * from (select * from (select empno,ename,sal,job,mgr,rownum from emp) order by rownum DESC) where rownum=1;

For remaining record you can use minus function with above out puts.