title: Informatica - loading to target takes too much time
body: <p>I've created a simple mapping in informatica,where i add in the source qualifier the following statement: select * from srcTbl where field1='Y'.
  I'm loading only 3 fields to the target table, only 1 of them is from the source, the other to is output fields with a short text values.</p>
  
  <p>the source and target are oracle tables, the target has index that is created by the 3 fields i'm loading.</p>
  
  <p>I've changed the load mode to Normal instead of bulk because i can't drop the index.</p>
  
  <p>it takes to much time, after an hour i just pressed abort.</p>
  
  <p>the session log said that it's in the loading process.</p>
  
  <p>what could be the reason for this process not to end quickly?</p>
  
  <p>thanks</p>