SELECT E.SUBJ_NAME AS FOLDERNAME,
D.TASK_NAME AS SESSIONNAME,
A.SESSION_ID AS SESSIONID,
B.INSTANCE_NAME AS INSTANCENAME,
DECODE (C.ATTR_VALUE, '0', 'NORMAL', '1', 'BULK', NULL)
AS TARGETLOADTYPE
FROM INFA_REP.OPB_SESSION A,
INFA_REP.OPB_SWIDGET_INST B,
INFA_REP.OPB_EXTN_ATTR C,
INFA_REP.OPB_TASK D,
INFA_REP.OPB_SUBJECT E
WHERE A.SESSION_ID = B.SESSION_ID
AND A.SESSION_ID = C.SESSION_ID
AND C.ATTR_ID = 3
AND B.SESS_WIDG_INST_ID = C.SESS_WIDG_INST_ID
AND A.SESSION_ID = D.TASK_ID
AND D.SUBJECT_ID = E.SUBJ_ID
AND E.SUBJ_NAME='FOLDER_NAME'
Awesome explanation pradeep
ReplyDeleteInformatica training in bangalore,informatica online training,infroamtica dataquality training in bangalore, informatica tutorials, best informatica training in bangalore, best informatica online training in bangalore