Tag: repository

Informatica Powercenter Repository : Find which session instances use a certain connection

If you want to check if a relational connection is still used in any session instance you can use the following query on the repository: SELECT M.MAPPING_NAME ,SI.INSTANCE_NAME INSTANCE_NAME ,SA.ATTR_VALUE TABLE_OWNER ,MSE.OBJECT_NAME READER_WRITER_TYPE ,C.OBJECT_NAME CONNECTION_NAME ,C.USER_NAME ,WA.ATTR_VALUE SQL_OVERRIDE FROM DWHREP.OPB_SWIDGET_INST SI ,DWHREP.OPB_SWIDGET_ATTR SA ,DWHREP.OPB_MAPPING M ,DWHREP.OPB_WIDGET_INST WI ,DWHREP.OPB_WIDGET_ATTR WA ,DWHREP.OPB_SESS_EXTNS SE ,DWHREP.OPB_MMD_SESS_EXTNS MSE ,DWHREP.OPB_SESS_CNX_REFS SCR …

Continue reading

Find SQL Override in Informatica Powercenter Repository

Make sure that you query the latest mapping version and widget_type = 3 (Source Qualifier). Then select attr_id = 1 and you get the SQL override (if used in the Source Qualifier).

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close