How to load first half data in one target table and 2nd half data in another using informatica IICS

In this video describe on How to load first half data in one target table and 2nd half data in another using informatica IICS

In our channel describe on Oracle SQL Interview Question and Answers || IICS Tutorial || Data Warehousing Concept| Linux
Please check below link for more oracle sql questions,

Please check below link for IICS tutorial series,
I have created playlist for Oracle SQL, IICS, DWH. Please check playlist u will get more knowledge on these (Oracle SQL, IICS, DWH).

[harishukkisala]

TBALE1

ID , NAME , SALARY
1 , RAM , 1000
2 , KIRAN , 1000
3 , VENKAT , 2000
4 , RAJU , 2000

TABLE2

ID , NAME , SALARY
1 , KIRAN , 1000
2 , VENKAT , 2000
3 , RAJU , 2000


OUTPUT SHOULD BE

ID , NAME , SALARY


1 , RAM , 1000 WRITE AN SQL QUERY IN ORACLE