Monday, April 7, 2014

How to serach Informatica mappings from meta data table suing Sql Query


SELECT DISTINCT C.SUBJ_NAME, B.MAPPING_NAME FROM
OPB_SUBJECT C, OPB_MAPPING B, OPB_WIDGET_INST A
WHERE C.SUBJ_ID = B.SUBJECT_ID AND B.MAPPING_ID = A.MAPPING_ID
AND upper(A.instance_NAME) LIKE upper('%MAP%')

No comments:

Post a Comment