What is Cartesian product?
Answers were Sorted based on User's Feedback
Answer / poornima
A Cartesian product is defined as all possible combinations
of rows in all tables.
| Is This Answer Correct ? | 80 Yes | 22 No |
Answer / subramanyam
it is a situation in which a Query includes two or more
tables that r not linked by join. if that query execute
that will retrive the all piossible combinationss between
the tables.in this Situtation cartision production occured.
| Is This Answer Correct ? | 36 Yes | 12 No |
Answer / nareshkumar
A Cartesian product is a result set which contains all the
possible combinations of each row in each table included in
a query. A Cartesian product is almost always an incorrect
result.
| Is This Answer Correct ? | 43 Yes | 24 No |
Answer / saravanan
Ans : When join condition is invalid or omitted
completely ,the result is carresion.
| Is This Answer Correct ? | 27 Yes | 14 No |
Answer / karthick
The result of cross join is called as Cartesin Product.
| Is This Answer Correct ? | 16 Yes | 8 No |
Answer / sandip dandapat
A Cartesion Product is defined as the all possible
combination from the tables. In other words a joining
without condition.
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / eng-wael
The Cartesian product, also referred to as a cross-join, returns all the rows in all the tables listed in the query. Each row in the first table is paired with all the rows in the second table. This happens when there is no relationship defined between the two tables. Both the AUTHOR and STORE tables have ten rows. If we use a Cartesian join in these two tables, we will get back 100 rows.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / chinna
A Cartesian product tends to generat a large number of
rows, and the result is rarely useful.You should always
include a valid join condition in a where clause,unless you
have a specific need to combine all rows from all tables.
| Is This Answer Correct ? | 12 Yes | 10 No |
Answer / angelina
the Cartesian product of two sets X (for example the points
on an x-axis) and Y (for example the points on a y-axis),
denoted X × Y, is the set of all possible ordered pairs
whose first component is a member of X and whose second
component is a member of Y (e.g., the whole of the x–y
plane):
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / vinod mishra
In mathematics, a Cartesian product (or product set) is a
construction to build a new set out of a number of given
sets. Each member of the Cartesian product corresponds to
the selection of one element each in every one of those sets.
| Is This Answer Correct ? | 1 Yes | 0 No |
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
when to go for alias and when to go for contexts
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?
How can we improve performance?
What is Indexing? how did u implement indexing?
Can any one say me wat does"maintanence of universe" means wit?
2 Answers Business Intelligence Analytics, NAL, TCS,
CAN WE CREATE VIEW IN BO (NOT DERIVED TABLES)?
Give some information on report bursting?
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ?
what is document design in boxi,have u participate in that
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
2 Answers Accenture, Rolta, TCS,