Framework - resolving ambiguous relationships

[fmwannabe]

Framework manager models are usually set up with 3 namespaces - one for imported data sources, one for working, and one for business presentation.

We also learned that the imported namespace should be kept as close to the source as possible, except for relationships.

My question is about resolving ambiguous relationships. Is it best to create query subject roles and resolve the relationships in the data source namespace or the working namespace?

Thanks.

 

[blom0344]

The namespace that holds the database objects may contain all sorts of ambiguous relationships as it is dictated by the source relationships. The second layer should be responsible for creating the proper star-models (and hence contain no ambiguouty at all)
In the end the model will dictate the join strategy between the model query subjects. (which you name as query subject roles)

Ties Blom