can I join like this?

[cognoshelp@ymail.com]

is it the right way to join QS in FM

please see the attachment...

[blom0344]

Such joins may appear in the datalayer of an OLTP schema. You should get rid of the loops/multiple paths in the modelling layer (in ALL cases)

[cognoshelp@ymail.com]

Such joins may appear in the datalayer of an OLTP schema. You should get rid of the loops/multiple paths in the modelling layer (in ALL cases)

what is the best way to resolve loop joins.

please let me know the steps which I need to follow

[wyconian]

Hi

It depends on what you're trying to achieve. In mos cases the best approach may be to have a number of start schemas with conformed dimension and possibly some snowflaking.

One of the ways to get rid of loops and multpath joins is to use aliases of the tables in the middle layer.  These are just copies of a table with a differnt name and different joins.