M

2 Messages

 • 

200 Points

Tuesday, April 23rd, 2024 10:40 PM

How To Show The Related Mapping Specification In The View of a Physical Data Dictionary

I have a column named Member_Name in my physical data dictionary EDWPRD.  It is part of the table MA_Member which is also part of the EDWPRD physical data dictionary.  I have a mapping specification named STM_D_Member and Member_Name is a source column in this mapping spec.  If I look in the details of the column Member_Name, I can see a section for Field Mapping which shows the mapping specification of STM_D_Member.  However, I can't seem to make this mapping specification show up in the view of the physical data dictionary EDWPRD.  The view of the physical data dictionary shows all of the columns and tables in this physical data dictionary and displays a list of records with column headings of Name, Status, Asset Type, and Is Part Of (the related table in the case of column assets).  When I add the fields "Data Structure source of Mapping Specification" and "Data Structure target of Mapping Specification", nothing appears in these fields even though I know the columns are part of a mapping specification.  What do I need to do to be able to display the mapping specification alongside the rest of the asset information?  Is it because it's not a 1-for-1 relationship and there could be many mapping specifications that the column is part of?

No Responses!
Loading...