SELECT DISTINCT
C.SUBJECT_AREA FOLDER_NAME,
C.MAPPING_NAME MAPPING_NAME,
C.SESSION_NAME SESSION_NAME,
E.READER_WRITER_TYPE,
E.INSTANCE_NAME,
E.CNX_NAME,
CASE
WHEN E.WIDGET_TYPE = 2
THEN 'TARGET CONNECTION'
ELSE
CASE
WHEN E.WIDGET_TYPE IN (1, 3, 56, 45, 55, 84)
THEN
'SOURCE CONNECTION'
ELSE
NULL
END
END CNX_TYPE
FROM INFA_REPO.REP_VERSION_PROPS A,
INFA_REPO.REP_USERS B,
INFA_REPO.REP_LOAD_SESSIONS C,
INFA_REPO.REP_REPOSIT_INFO D,
INFA_REPO.REP_SESS_WIDGET_CNXS E
WHERE ( A.USER_ID = B.USER_ID
AND C.SESSION_ID <> D.REPOSITORY_ID
AND C.SESSION_ID = A.OBJECT_ID
AND C.SUBJECT_ID = A.SUBJECT_ID
AND A.OBJECT_TYPE = 68
AND C.SESSION_ID = E.SESSION_ID
AND C.SESSION_VERSION_NUMBER =
E.SESSION_VERSION_NUMBER)
I get a lot of great information from this blog. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
ReplyDeleteinformatica training in hyderabad
informatica etl data lineafe sql nice posts..
ReplyDeleteinformatica online training
OBI Apps, OBIEE, Data Warehouse, Informatica, DAC,PL/SQL nice posrts..
ReplyDeleteinformatica training
Useful Information :
ReplyDeleteLooking for the Best [url= Digital Marketing in Vijayawada ][/url] , We provide training on live projects, internship, Flexible Classes, Free Demo @ praiseads.com
Interesting blog, here a lot of valuable information is available, it is very useful information Keep do posting i like to follow this informatica online training
ReplyDeleteinformatica online course
informatica bdm training
informatica developer training
informatica training
informatica course
informatica axon training
informatica developer training
informatica developer course