Scenarios

Load first half records to Target in Informatica

  • Create source and target with same structure and drag them into the mapping designer.  
  • Edit source qualifier-> Go to properties->Click on SQL query
  • SQL editor will be opened. Write below query. 
                select * from emp where rowmum<=(select count(*)/2 from emp)
  • Validate->OK
  • Connect source qualifier and target.  
Powered by Blogger.