Scenario 8: How to send second  half record to target?

Solution
Step 1: Drag and drop the source to mapping.

src to tgt mapping
Step 2: In source-Qualifier  , go to propery and write the SQL query like

select * from emp minus select * from emp where rownum <= ( select count(*)/2 from emp))

src qualifier sql query

Step:3 Then connect to target, and run mapping to see the results.