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.
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.
This is nice article and very good explanation
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
very nice article.Thanks for sharing the post...!
ReplyDeleteSolaris Training
SQL and Plsql Training
I feel SQL and other aspects really help people provide more and more useful aspects to learn from after solving very complex IT problems.
ReplyDeleteInformatica Read Rest API