Scenario 8: How to send second half record to target?
Step 1: Drag and drop the source to 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))
Step:3 Then connect to target, and run mapping to see the results.