Informatica help

Informatica help and metadata report query

Mapping Object-Level Connections

Mapping Object-Level Connections

Displays all transformations from source to target in a mapping and how they are connected to each other.


Click on the text to copy the query report to your clipboard.


select "FROM_DESCRIPTION",
"MAPPING_NAME",
"FROM_TYPE",
"TO_NAME",
"TO_DESCRIPTION",
"TO_TYPE",
"FROM_NAME",
"REPOSITORY_NAME",
"SUBJECT_AREA"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_FROM_WIDGET_INST.INSTANCE_NAME as FROM_NAME,  MAPPING_FROM_WIDGET_INST.WIDGET_TYPE_NAME as FROM_TYPE ,  MAPPING_FROM_WIDGET_INST.DESCRIPTION as FROM_DESCRIPTION ,  MAPPING_TO_WIDGET_INST.INSTANCE_NAME as TO_NAME ,  MAPPING_TO_WIDGET_INST.WIDGET_TYPE_NAME as TO_TYPE ,  MAPPING_TO_WIDGET_INST.DESCRIPTION as TO_DESCRIPTION from  REP_WIDGET_DEP MAPPING_WIDGET_DEP,  REP_WIDGET_INST MAPPING_FROM_WIDGET_INST,  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_WIDGET_INST MAPPING_TO_WIDGET_INST  WHERE  (MAPPING_WIDGET_DEP.FROM_INSTANCE_ID = MAPPING_FROM_WIDGET_INST.INSTANCE_ID   AND  MAPPING_WIDGET_DEP.MAPPING_ID = MAPPING_FROM_WIDGET_INST.MAPPING_ID AND  MAPPING_WIDGET_DEP.VERSION_NUMBER = MAPPING_FROM_WIDGET_INST.VERSION_NUMBER   AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_WIDGET_DEP.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_WIDGET_DEP.  VERSION_NUMBER AND  ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  MAPPING_WIDGET_DEP.TO_INSTANCE_ID = MAPPING_TO_WIDGET_INST.INSTANCE_ID AND  MAPPING_WIDGET_DEP.MAPPING_ID = MAPPING_TO_WIDGET_INST.MAPPING_ID AND  MAPPING_WIDGET_DEP.VERSION_NUMBER = MAPPING_TO_WIDGET_INST.VERSION_NUMBER)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME", "FROM_NAME", "FROM_TYPE", "FROM_DESCRIPTION"

Has one comment to “Mapping Object-Level Connections”

You can leave a reply or Trackback this post.
  1. inforum - Sep 28, 2017 Reply

    I don’t know how I missed this, but I’m thankful I’ve found it now. Many thanks for posting.

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast