Saturday, December 8, 2012

Sending first half record to target

How to send first half record to target?
Solution:
1. Drag and drop the source to mapping.

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



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

1 comment:

Thank you :
- kareem