Is it possible to create a non-identifying relationship in the physical model where I can select the parent and child? I am working with a DB that was designed w/o FK and I am trying to model it in a way that others can understand how tables relate to one another. I would rather not use the the line option as it does not allow for naming the line. I am using a SQL Server model.
Thanks…Mike
Hi,
yes, this is possible.
In version 3.x it was necessary to manually map the attributes:
http://modeling.inside.quest.com/entry.jspa?externalID=1668&categoryID=158
In version 4.2 automatic foreign keys mapping is available:
http://modeling.inside.quest.com/entry.jspa?externalID=4825&categoryID=158
Regards,
Vaclav
I have updated the setting to ‘always ask’ yet I am still unable to set the parent and child values. Any other options?
Thanks…Mike J
Hi,
the attributes must have the same name and data type. Otherwise you will have to edit the relationship and map the attributes manually. See the first movie.
Regards,
Vaclav
Understood…But that still does not allow for me to change the attribute of the parent - only the PK is allowed. If that is the case, is there another way of displaying a non-identifying relationship in a PM? I am using TDM 4.2
Hi,
if you wish to change parent attribute, edit the parent entity, create new alternate key on tab Keys and add the required attribute to the alternate key. Then edit the relationship and on tab Foreign Keys select the new alternate key from combo box Parent Key.
Regards,
Vaclav
Thanks for the help. Although not elegant, it will work for this situation.
Hi,
thank you for your feedback. Unfortunately I think there won’t be much elegant solutions, due to the fact that there are some rules that should be followed (create relationships only via existing keys and not on columns that do not belong to any key etc.).
Regards,
Vaclav