- Drag source and target into the mapping.
- Let us assume EMP is source, and create a new table say T_EMP with same structure as EMP.
- Create the mapping as shown below:
- Now edit Source Qualifier tranformation and click on properties tab.
- Enter the following query in SQL Query property:
- Save the mapping.
- Finally create session, Workflow and run thee workflow.
SELECT * FROM emp WHERE ROWNUM <= (SELECT COUNT(*)/2 FROM emp
Great Article
ReplyDeleteArtificial Intelligence Projects
machine learning final year projects 2020
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai