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.
This article is very nice and informative to learners
ReplyDeleteInformatica training, informatica training in bangalore, informatica online training