Tuesday, January 5, 2021

Data Quality Elements (DQ Mapplets within PowerCenter)


SELECT OPB_SUBJECT.SUBJ_NAME AS PROJ,

       OPB_MAPPING.MAPPING_NAME AS MAPPING,

       OPB_WIDGET_INST.INSTANCE_NAME AS TRANSFORMATION,

       OPB_WIDGET.LAST_SAVED AS LAST_SAVED

FROM OPB_WIDGET_INST

  INNER JOIN OPB_MAPPING ON OPB_WIDGET_INST.MAPPING_ID = OPB_MAPPING.MAPPING_ID

  INNER JOIN OPB_SUBJECT ON OPB_MAPPING.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID

  INNER JOIN OPB_WIDGET ON OPB_WIDGET_INST.WIDGET_ID = OPB_WIDGET.WIDGET_ID

WHERE OPB_WIDGET.TEMPLATE_ID IN (SELECT PLG_ID FROM OPB_MMD_CATALOG WHERE PLG_DESC LIKE '%Data Quality%');





No comments:

Post a Comment