Scenario 6: How to send first half record to target?
- Drag and drop the source to mapping.
- Step:2 In source-Qualifier , go to property and write the SQL query like
select * from emp where rownum <= ( select count(*)/2 from emp)
- Then connect to target.Now you are ready to run the mapping to see it in action.