| |
GeekInterview.com > Interview Questions > Data Warehousing > BO Designer
| Print | |
Question: Cartesian product
Answer: A situation in which a query includes two or more tables that are not linked by a join. If executed, this type of query retrieves all possible combinations between each table and may lead to inaccurate results.
|
| January 01, 2006 00:32:23 |
#2 |
| Sithu |
Database Expert Member Since: December 2005 Total Comments: 161 |
RE: Cartesian product
|
A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself. Cheers, Sithu |
| |
Back To Question | |
