Hope this will help you :
DISTINCT MAPPING_FLD_MAPPING.TRANS_EXPRESSION, MAPPING_FLD_MAPPING.SOURCE_FIELD_NAME, MAPPING_FLD_MAPPING.SOURCE_NAME, MAPPING_FLD_MAPPING.TARGET_COLUMN_NAME, MAPPING_FLD_MAPPING.TARGET_NAME
I am unable to see table or view named as REP_FLD_MAPPING MAPPING_FLD_MAPPING in our metatdata manager schema.
I see lot of tables named with IDP_, IMC, IME, IMS etc.
Stop, stop, stop.
The original question sounds like a PowerCenter related question, but it is related to the lineage in Metadata Manager.
I don't know much about MM, so I can't tell whether MM offers any such capability. Can please someone knowledgeable in MM respond to this question?
You can use IMA_ELMNT_ASSOC view to get the parent-child relationship information.
Sample query for Parent-Child Relationship would look like:
SELECT E.REPOSITORY_NAME AS RESOURCE_NAME, E.ELEMENT_NAME AS PARENT_NAME, E.CLASS_LABEL AS PARENT_OBJECT_TYPE,E1.ELEMENT_NAME AS CHILD_NAME, E1.CLASS_LABEL AS CHILD_OBJECT_TYPE
FROM IMA_ELMNT_ASSOC A, IMA_ELEMENT E, IMA_ELEMENT E1
Thanks a lot for looking into this. Your query helps.
Is there any specific use of using ASSOCIATION_UID ?
I am looking for field/column level parent/child flow from end to end.
This data is used to do impact analysis whenever we are touching a field.
it is not that simple to get the end to end report at column level, for which we have lineage diagram.
you can export the lineage to excel and check the details