title: Query to get a field to field logic from source to target using informatica repository tables
body: <p>I would like to get a query for source to target field flow using informatica repository tables like for example the repository view : REP_MAPPING_CONN_PORTS.</p>
  
  <p>We do not have any additional licensing for the Metadata Manager. Idea is to basically automate the end to end source to target logical flow of all fields in a mapping. Say after every release, a job runs which automatically updates the logical flow, which would then be very easy for any person to go through and understand the logic.</p>
  
  <p>say something like if i have a mapping m_temp, with say 4 transformations :</p>
  
  <p>Source --> Source Qualifier --> Expression --> Target</p>
  
  <p>I need to extract the data from the repository say something like below, so that i can then showcase it in a front end tool of some sort.</p>
  
  <p>Say in the above mapping, FIELD_1 starts from the Source flowing though SQ and there is a logical IF in the expression which then is connected to a field FIELD_2 in the Target. This is how i expect the output of the query to be.</p>
  
  <p>From                   Logic                            TO</p>
  
  <p>FIELD_1           IF(FIELD_1='1','A','B')                    FIELD_2</p>
  
  <p>Could someone please assist me on a query that i could use to run on the informatica Repository?</p>