Mapping transformation Port Details

Displays ports in a transformation by repository, folder, and mapping. It also displays properties of the ports. This report is the second node in a workflow associated with the Mapping List primary report.


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


select "MAPPING_NAME",
"EXPRESSION",
"DATATYPE",
"SUBJECT_AREA",
"WIDGET_TYPE_NAME",
"DESCRIPTION",
"WGT_PREC",
"DEFAULT_VALUE",
"WIDGET_NAME",
case when ("PORTTYPE" <= 10) then (case when ("PORTTYPE" = 1) then ('Input Port') else (case when ("PORTTYPE" = 2) then ('Output Port') else (case when ("PORTTYPE" = 3) then ('Input Output Port') else (case when ("PORTTYPE" = 6) then ('Return Port') else (case when ("PORTTYPE" = 7) then ('Input Return Port') else (case when ("PORTTYPE" = 8) then ('Lookup Port') else (case when ("PORTTYPE" = 10) then ('Output Lookup Port') else (null) end) end) end) end) end) end) end) else (case when ("PORTTYPE" = 14) then ('Lookup Return Port') else (case when ("PORTTYPE" = 32) then ('Variable Port') else (case when ("PORTTYPE" = 65) then ('Input Port and Master Detail Port') else (case when ("PORTTYPE" = 67) then ('Input Port, Output Port and Master Detail Port') else (case when ("PORTTYPE" = 130) then ('Output Port and Generated Key Port') else (case when ("PORTTYPE" = 258) then ('Output Port and Generated Column ID Port') else (case when ("PORTTYPE" = 515) then ('Input Port, Output Port and Message ID Port') else (case when ("PORTTYPE" = 1027) then ('Input Port, Output Port and Message Data Port') else (case when ("PORTTYPE" = 2050) then ('Dynamic Lookup Port') else (null) end) end) end) end) end) end) end) end) end) end as "Calc_PORTTYPE",
"REPOSITORY_NAME",
"WGT_SCALE",
"FIELD_NAME"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME,  ALL_MAPPINGS.SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME,  MAPPING_ALL_TRANSFORMS.WIDGET_TYPE_NAME,  MAPPING_ALL_TRANSFORMS.WIDGET_NAME,  MAPPING_TRANSFORM_WIDGET_FIELD.FIELD_ORDER,  MAPPING_TRANSFORM_WIDGET_FIELD.FIELD_NAME,  MAPPING_TRANSFORM_WIDGET_FIELD.DESCRIPTION as DESCRIPTION,  MAPPING_TRANSFORM_WIDGET_FIELD.PORTTYPE,   MAPPING_TRANSFORM_WIDGET_FIELD.DATATYPE,  MAPPING_TRANSFORM_WIDGET_FIELD.WGT_PREC,  MAPPING_TRANSFORM_WIDGET_FIELD.WGT_SCALE,  MAPPING_TRANSFORM_WIDGET_FIELD.DEFAULT_VALUE as DEFAULT_VALUE,  MAPPING_TRANSFORM_WIDGET_FIELD.EXPRESSION as  EXPRESSION FROM REP_ALL_MAPPINGS ALL_MAPPINGS, REP_REPOSIT_INFO MAPPING_REPOSIT_INFO, REP_WIDGET_INST MAPPING_WIDGET_INST, REP_ALL_TRANSFORMS MAPPING_ALL_TRANSFORMS, REP_WIDGET_FIELD MAPPING_TRANSFORM_WIDGET_FIELD  WHERE  (ALL_MAPPINGS.PARENT_MAPPING_ID <> MAPPING_REPOSIT_INFO.REPOSITORY_ID AND  ALL_MAPPINGS.PARENT_MAPPING_ID = MAPPING_WIDGET_INST.MAPPING_ID AND  ALL_MAPPINGS.PARENT_MAPPING_VERSION_NUMBER = MAPPING_WIDGET_INST.  VERSION_NUMBER AND  ALL_MAPPINGS.PARENT_SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_ALL_TRANSFORMS.PARENT_WIDGET_ID = MAPPING_TRANSFORM_WIDGET_FIELD.  WIDGET_ID AND  MAPPING_ALL_TRANSFORMS.PARENT_WIDGET_VERSION_NUMBER =   MAPPING_TRANSFORM_WIDGET_FIELD.VERSION_NUMBER AND  MAPPING_ALL_TRANSFORMS.PARENT_WIDGET_ID = MAPPING_WIDGET_INST.WIDGET_ID AND  MAPPING_ALL_TRANSFORMS.SUBJECT_ID = MAPPING_WIDGET_INST.SUBJECT_ID AND  MAPPING_ALL_TRANSFORMS.WIDGET_TYPE_ID = MAPPING_WIDGET_INST.WIDGET_TYPE )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "MAPPING_NAME" in ('<Mapping_Name>')
order by "REPOSITORY_NAME", "SUBJECT_AREA", "MAPPING_NAME"

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*