Half records to one target another Half to other..

--  In order to achieve this.. we need to design two pipelines..


-- In the first pipeline override the SQL Query as

  SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
 EMP WHERE ROWNUM < = (SELECT COUNT(*) /2 FROM EMP )

-- In the Second pipeline override the SQL Query as

  

SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
 EMP
MINUS
SELECT EMP.EMPNO, EMP.ENAME, EMP.JOB, EMP.MGR, EMP.HIREDATE, EMP.SAL, EMP.COMM, EMP.DEPTNO
FROM
 EMP WHERE ROWNUM <=(SELECT COUNT(*)/2 FROM EMP)

 -- Ram