is it the right way to join QS in FM
please see the attachment...
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)
Quote from: blom0344 on 31 Jul 2008 10:07:18 AM
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
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.