in my model I have two schemas, core and star, where core represents normalized tables and star is used for business intelligence.
There are many tables with the same name which have also similar relationships. In SQL Server the names must be unique within one schema only, so it is allowed to have two foreign keys with the same name if they are in different schemas.
But TDM always shows an error about duplicate constraint names.
Is there a way to disable these error messages?
And can I have confidence that TDM will handle these relationships correctly?
Thanks and best regards,