Informatica Views, also known as informatica metadata tables/Views provides object named as REP_SESS_TBL_LOG, Which can be used to get all the sessions populating specific target table.
For example, you might need to know all informatica sessions feeding to target tables (Downstream system), which are supposed to be abandoned.This is a common scenario in organizations which are driving application transformation initiative and knowing this helps to decide mappings where code change is needed.
Moreover, knowing this info also help if someone is in application enhancement phase. where some systems are getting obsolete. all database objects also need to be cleaned up in respective client applications. To be in sync with other application changes.
What if one fine day you get to know that your CRM system is migrating to SAP and you will no longer be receiving data from CRM , Lets assume if you are feeding to CRM then all your jobs pointing to it will start aborting one by one. and to avoid this you need to know sessions pointing to CRM tables.
Here is SQL query to know informatica sessions populating specific target table.
select SUBJECT_AREA, SESSION_NAME, MAX(SUCC_ROWS) AS TGT_SUCC_ROWS#, TYPE_ID, COUNT(1) CNT_SUB_ARA#, TARGET_NAME from ( select SESSION_INSTANCE_NAME SESSION_NAME,SUBJECT_AREA, TYPE_ID, SUCCESSFUL_AFFECTED_ROWS SUCC_ROWS, TABLE_NAME TARGET_NAME from INFORMATICAPC9.REP_SESS_TBL_LOG WHERE TYPE_ID in (2) and END_TIME >= TRUNC(SYSDATE-60) and SUCCESSFUL_AFFECTED_ROWS > 0 and TABLE_NAME like :TABLE_NAME_SEARCHED_FOR||'%' ESCAPE '\' ) Group By SUBJECT_AREA, SESSION_NAME, TARGET_NAME, TYPE_ID Order By SUBJECT_AREA, TARGET_NAME, SESSION_NAME ;