Informatica OPB table which have gives source table and the mappings and folders using an sql query

                                                                                                                                                                      

Scenario:

Informatica OPB table which have gives source table and the mappings and folders using an sql query

 Solution:

-          SQL query

select OPB_SUBJECT.SUBJ_NAME, 

             OPB_MAPPING.MAPPING_NAME,

             OPB_SRC.source_name

from opb_mapping, opb_subject, opb_src, opb_widget_inst

   where opb_subject.SUBJ_ID = opb_mapping.SUBJECT_ID

                 and OPB_MAPPING.MAPPING_ID = OPB_WIDGET_INST.MAPPING_ID

                 and OPB_WIDGET_Inst.WIDGET_ID = OPB_SRC.SRC_ID

                 and OPB_widget_inst.widget_type=1;