Cartesian Problem

Group,

In v5 if you put a soft join (a join condition in the where clause) even if the tables were not previously joined in the universe, you would not get a cartesion (by my recollection). In v6, you gget the cartesian warning.

Any thoughts about how to get around that . I am joining a table to a calendar table - do NOT want to have to alias it - there are ~20 tables that I will need to do this with.

:confused: :cuss:


Charles Killam :us: (BOB member since 2003-04-24)

Use seperate queries for the two tables and link them in the data manager.
In this way you will get an outer join.


PBS_rocks (BOB member since 2004-03-17)

Hmmmm. I donโ€™t remember V5 working that way, but Iโ€™m not sure.

What I do is to build a dummy join. Something like [list]fact_table.partnumber<>calendar_table.monthname[/list]

It still generates a cartesian product; BO just doesnโ€™t think so.


Steve Krandel :us: (BOB member since 2002-06-25)