What is the proper way to create a new n:m relationship between two tables when the tables both share some common key attributes that are not a part of the rest of the schema? For example:
Entity: shipment_slice - PK attributes are:
Entity: post_fulfillment_slice - PK attributes are:
Some of the common columns have their original in the PK of other entities (like order_id, product_id). However, the file_id, segment_code, and mailkey_code only exist in these two entities above.
When creating a n:m relationship, TDM will correctly consolidate order_id and product_id, so that they only appear once in the join entity. It also correctly adds the address_id and parm_id attributes from shipment_slice and post_fulfillment_slice, respectively.
However, the other attributes that are common (file_id, segment_code, and mailkey_code mentioned above) are duplicated in the join table. I do not see any way to manually fix this either (ie. tell TDM that the file_id on the left is the same as the one on the right).