Scenario 6: How to send first half record to target?

Solution:

  1.  Drag and drop the source to mapping.

    src to target mapping
  2. Step:2 In source-Qualifier  , go to property and write the SQL query like
    select * from emp where rownum <= ( select count(*)/2 from emp)
    

    src qualifier sql query
  3. Then connect to target.Now you are ready to run the mapping to see it in action.