CODEWITHSUNDEEP
metadatainformatica
Fermin
Fermin

Reputation: 473

Informatica 9.6 How to query mapping ports from source to target?

I have a basic mapping:

I know it is possible to somehow query the metadata, but I do not know how or what tool to use.

How can I get a list of all starting source columns(output ports at source) linked to their final target column(input ports at target)?

Having the intermediate steps (example, source to joiner, joiner to expression, expression to target), would be very helpful as well, but source to target is the most important.

Upvotes: 0

Views: 935

Answers (2)

Chinmay T
Chinmay T

Reputation: 1133

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.

Upvotes: 0

Maciejg
Maciejg

Reputation: 3353

Querying metadata is not very convenient. You can try to export your mapping to XML and use http://powercenter-xmlanalyzer.appspot.com/ to do the source-to-target dependency analysis for you.

Upvotes: 0

Related Questions