How to query all sessions that are using a VIEW?
<p>I'm looking for a way to query the repository tables of informatica and get back all the sessions that are using a view.</p>

<p>These are the tables I searched in :</p>

<pre><code>      OPB_SESS_FILE_VALS
      OPB_SESSION
      OPB_MAPPING
      OPB_SUBJECT
      OPB_TASK
      REP_SESSION_INSTANCES
      OPB_TASK_INST
</code></pre>

<p>I tried to search online, go through almost all the tables but didn't find a way to know if a task is a view or not . <br>I can use <code>TASK_NAME LIKE 'V_%'</code> but it won't be 100% correct as not all our views are named standard . </p>

<p>Thanks.</p>