informatica - 查找影响 informatica 中特定表的映射和工作流程列表

Question

谁能告诉我如何查找使用特定表(如 X)作为源表或目标表的映射列表和工作流程？

Answer 1

Informatica 元数据存储库存储并维护有关 Informatica 中所有对象的信息。因此，您必须编写外部查询来查找此信息:

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

并查找工作流程:

 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'));