Analytics Software

Hi ,

Is it possible a logical table has 2 logical table sources and there is no join between the underlying table of logical table sources?
What will happen if we create the request which contains one attribute from each source?
Will BI server return records with Cartesian join?

Is it mandatory if logical table is having more than one logical table sources(exp. Logical table sources are X,Y and underlying table is A,B respectively),
The underlying tables (A&B) must be joined ?

Can someone explain the logic behind the logical table sources? How does it work?
Any reference of document will be appreciable.

Thanks,Ashish