find the list of mapping and workflow affecting the particular table in informatica

Question

Can anyone tell me how to find the list of mapping and the workflow that are using a particular table say X either as a source or target table?

Answer 1

Informatica metadata repository stores and maintains information about all the objects in Informatica.So , you have to write an external query to find this :

  SELECT   SUBJECT_AREA , MAPPING_NAME
  FROM REP_ALL_MAPPINGS
  where MAPPING_NAME in (
  SELECT MAPPING_NAME FROM REP_SRC_MAPPING
  where SOURCE_NAME ='X')

And to find workflows :

 select REP_WORKFLOWS.SUBJECT_AREA, REP_WORKFLOWS.WORKFLOW_NAME
 from dbo.REP_WORKFLOWS
 join dbo.REP_WFLOW_RUN
 on REP_WORKFLOWS.WORKFLOW_ID = REP_WFLOW_RUN.WORKFLOW_ID
 where REP_WORKFLOWS.SUBJECT_AREA  in 
 (SELECT   SUBJECT_AREA 
  FROM REP_ALL_MAPPINGS
  where MAPPING_NAME in (SELECT MAPPING_NAME FROM REP_SRC_MAPPING
  where SOURCE_NAME ='X'));