Mapping transformations report

Displays transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.

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


select case when ("IS_SHORTCUT" = 1) then ('Yes') else ('No') end as "Calc_IS_SHORTCUT",
case when ("WIDGET_VERSION_STATUS" = 0) then ('Active') else (case when ("WIDGET_VERSION_STATUS" = 9) then ('Logically Deleted') else (case when ("WIDGET_VERSION_STATUS" = 10) then ('Physically Deleted') else ('') end) end) end as "Calc_WIDGET_VERSION_STATUS",
"WIDGET_NAME",
"MAPPING_NAME",
"WIDGET_DESCRIPTION",
"WIDGET_TYPE_NAME",
case when ("PARENT_WIDGET_IS_REUSABLE" = 1) then ('Yes') else ('No') end as "Calc_PARENT_WIDGET_IS_REUSABLE",
"WIDGET_VERSION_NUMBER",
"REPOSITORY_NAME",
"SUBJECT_AREA"
from (SELECT  DISTINCT MAPPING_REPOSIT_INFO.REPOSITORY_NAME              AS   REPOSITORY_NAME,  MAPPING_ALL_TRANSFORMS.SUBJECT_AREA                        AS SUBJECT_AREA,  ALL_MAPPINGS.MAPPING_NAME                                  AS MAPPING_NAME,  MAPPING_ALL_TRANSFORMS.WIDGET_TYPE_NAME                    AS   WIDGET_TYPE_NAME,  MAPPING_ALL_TRANSFORMS.WIDGET_NAME                         AS WIDGET_NAME,  MAPPING_ALL_TRANSFORMS.WIDGET_DESCRIPTION AS   WIDGET_DESCRIPTION,  MAPPING_ALL_TRANSFORMS.WIDGET_VERSION_NUMBER               AS   WIDGET_VERSION_NUMBER,  MAPPING_ALL_TRANSFORMS.WIDGET_VERSION_STATUS               AS   WIDGET_VERSION_STATUS ,  MAPPING_ALL_TRANSFORMS.PARENT_WIDGET_IS_REUSABLE           AS   PARENT_WIDGET_IS_REUSABLE,  MAPPING_ALL_TRANSFORMS.IS_SHORTCUT                         AS IS_SHORTCUT  FROM  REP_ALL_MAPPINGS ALL_MAPPINGS,  REP_REPOSIT_INFO MAPPING_REPOSIT_INFO,  REP_WIDGET_INST MAPPING_WIDGET_INST,  REP_ALL_TRANSFORMS MAPPING_ALL_TRANSFORMS  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_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", "WIDGET_TYPE_NAME", "WIDGET_NAME"