I tried approach mentioned in another answer but it was not working for me as I had custom transformation which was creating a huge xml file and it was very time taking. The tool mentioned in that answer was not available as well.

This is the reason I am adding this answer may be still helpful to someone facing similar issue.

There is way to use below metadata query. I tried this on Informatica PowerCenter Informatica 9.X.

SELECT * FROM REP_MAPPING_CONN_PORTS where mapping_name LIKE '%m_MappingName%';

• Above metadata query returns all the mapping ports connected from one transformation to another transformation for a mapping. Including source, target, all types of the transformation including custom transformations.

• You can filter data using Mapping_ID, Subject_Area, Mapping_Name, Mapping_Version_Number, From/TO_Object_Name(transformation names) etc. to get connected port information between transformations.

• You need to connect to Informatica database/schema where it is having other metadata stored. Normally, it is the database/schema used during installation of PC Informatica.