title: INFORMATICA Source qualifier SQL query
body: <p>I'm new to informatica. I was going through few mapping in which one had 4 source table (oracle)connected to single source qualifier and they used SQL queries in SQ.  </p>
  
  <p>In SQ- SQL query part: They used 6 tables with some joins to pick few columns(from all 6 tbls) where couple of fields doesn't exist in source definition itself.<br>
  Questions: In that case, is it necessary to connect the port from source definition to SQ?  </p>
  
  <p>Can we use union function inside SQL query?</p>
  
  <p>Thank you in advance!!!</p>