How to get relational connection details used in Informatica?

Below is the query to get relation connection details in Informatica 8series.

select * from V_PC8X_CONNECTION where CONNECTION_NAME IN
(select DISTINCT CONNECTION_NAME from REP_SESSION_CNXS where SUBJECT_AREA='FOLDER_NAME');


If you want to get connection details used in particular folder then you need to pass the FOLDER_NAME as input to the above query.
Above query will give details like Connection name, Host name, database type, user name, Connection string and more.

How to find target load type(Whether it is 'Bulk' or 'Normal' ) in session properties?

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'