title: Update query in pre sql of source qualifier is running but not commiting the table?
body: <p><a href="https://i.stack.imgur.com/XOtkH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XOtkH.jpg" alt="enter image description here" /></a>Below given query is executed using Source qualifier in Informatica.</p>
  <p>Pre SQL has the below query.</p>
  <pre><code>Update CTLSTAGE.VMR226DEV_HSD_SUB A
    set A.ATM_IP_IND = 'ATM'
  where (A.SW_SITE_CD,A.DEV_NM) = (
                                   select SW_SITE_CD,DEV_NM
                                   from CTLSTAGE.ATM_IP_REF
                                   where FTTC_E_IND = 'Y'
                                  ) ;
  COMMIT ;
  </code></pre>
  <p>Which is running but not committing in database.</p>
  <p><a href="https://i.stack.imgur.com/3spDy.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3spDy.jpg" alt="enter image description here" /></a></p>