Get Informatica 9.x Domain Details from Metadata

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 ;