title: Why is Informatica lookup returning NULL when all conditions are true?
body: <p>I am using a connected lookup to get a value when match conditions are found. However, the lookup is returning NULL value when in database a non NULL value is present. </p>
  
  <p>I have verified in Informatica Debugger and the database that all the conditions are matching and there is corresponding value is present. </p>
  
  <p>Here are the screenshots: -</p>
  
  <p>Debugger: - (I noticed a little red exclamation mark on the lookup port, I am not sure what does it signify)</p>
  
  <p>Onerosity Tag is the lookup value. Lookup condition used in Ports 2 to 7</p>
  
  <p><a href="https://i.stack.imgur.com/IEXKr.png" rel="nofollow noreferrer">Informatica_Debugger</a></p>
  
  <p>Informatica Verbose Mode Logs: -</p>
  
  <p><a href="https://i.stack.imgur.com/QatXN.png" rel="nofollow noreferrer">Verbose_Mode Logs</a></p>
  
  <p>Lookup Table data: -
  <a href="https://i.stack.imgur.com/ERalB.png" rel="nofollow noreferrer">Lookup_Table</a></p>
  
  <p>Result when I use join in SQL: -
  <a href="https://i.stack.imgur.com/1ikGv.png" rel="nofollow noreferrer">SQL Join</a>
  <a href="https://i.stack.imgur.com/fuSWn.png" rel="nofollow noreferrer">Result</a></p>
  
  <p>It seems like there is some minor change I need to make but I am not able to figure out what it would be.</p>