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.  
  

SHARES

Share

Pin it

Tweet

Share

Share

Share

Buffer

Print