[Mondrian] Using outer joins

Nizar Mabroukeh nmabroukeh at crosscommercemedia.com
Thu Oct 25 10:27:13 EDT 2012


Hi

To my humble understanding, and please correct me if I am wrong, Mondrian
uses full outer joins to join dimension tables with fact tables in a
snowflake schema, and uses right outer joins to join dimension tables with
fact tables in a star schema.
I am not sure if my understanding is completely right and I will appreciate
an assertion.
If my understanding is completely right, then Mondrian will not require
full outer joins if a star schema is always enforced, and will never
require left outer joins.

Any feedback is appreciated. Thanks.

Nizar Mabroukeh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20121025/12c93377/attachment.html 


More information about the Mondrian mailing list