This blog is the best online resource for informatica tutorial. It contains informatica queries and informatica new updates.
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