List
When is it OK to do Cartesian joins?
1) It looks like during the star transformation while joining 2 or more
small result sets from dimension tables?
2) In an ordinary join, when one of the row sources is estimated to be 1
row with the other row source be several thousand? In this case, the
Cartesian will be just 1*no of rows in the other table.
Any explanation is helpful. thanks
Orlando.