Pages

Sunday, March 17, 2013

How to send second half record to target?


Solution 
Step 1: Drag and drop the source to mapping.
src to tgt mapping
SRC TO TGT MAPPING

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

?
1
select * from emp minus select * from emp where rownum <= ( select count(*)/2 from emp))
src qualifier sql query
SRC QUALIFIER SQL QUERY

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

No comments:

Post a Comment