Mapping Port-Level Connections

This report will displays all transformations from source to target in a mapping and how they are connected to each other through ports.


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


select "FROM_OBJECT_FIELD_NAME",
"FROM_OBJECT_NAME",
"TO_OBJECT_FIELD_NAME",
"FROM_OBJECT_TYPE_NAME",
"TO_OBJECT_TYPE_NAME",
"REPOSITORY_NAME",
"SUBJECT_AREA",
"TO_OBJECT_NAME",
"MAPPING_NAME"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_CONN_PORTS.FROM_OBJECT_NAME,  MAPPING_CONN_PORTS.FROM_OBJECT_TYPE_NAME,  MAPPING_CONN_PORTS.FROM_OBJECT_FIELD_NAME,  MAPPING_CONN_PORTS.TO_OBJECT_NAME,  MAPPING_CONN_PORTS.TO_OBJECT_TYPE_NAME,  MAPPING_CONN_PORTS.TO_OBJECT_FIELD_NAME  FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_MAPPING_CONN_PORTS MAPPING_CONN_PORTS  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_CONN_PORTS.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_CONN_PORTS.  MAPPING_VERSION_NUMBER AND  ALL_MAPPINGS.SUBJECT_ID = MAPPING_CONN_PORTS.SUBJECT_ID)) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA"