Get Informatica 9.x Domain Details from Metadata

Posted on June 14, 2012 by Paul McGarrick
Filed Under BI Apps, Informatica

When setting up Informatica Client tools you might get stuck wondering what settings to use for the Domain and Port number. Presumably you will know the machine host name to use. You can use some sql against the Informatica metadata tables to help you figure out the required settings. E.g. something like this:

SELECT
RINF.PCSF_DOMAIN DOMAIN,
RINF.REPOSITORY_NAME,
NVL(RINF.PORTNUM,655) PORT
FROM
OPB_REPOSIT R,
OPB_REPOSIT_INFO RINF
WHERE
R.REPOSIT_NAME = RINF.REPOSITORY_NAME
AND R.RECID = 1 ;

Comments

2 Responses to “Get Informatica 9.x Domain Details from Metadata”

  1. Get Informatica Node Name | obieefans.com on July 9th, 2012 8:33 pm

    […] to my earlier post where I queried the metadata schema to get various Informatica parameters, I thought I would share this quick […]

  2. Walter on December 7th, 2012 5:04 pm

    It is great helpful while trying to upgrade PC8.6 to PC9.1
    Thanks

Leave a Reply




Please fill in this CAPTCHA to prove you\'re a human: Time limit is exhausted. Please reload CAPTCHA.