What are Cartesian joins?
Answers were Sorted based on User's Feedback
Answer / guest
joining 2 tables with out conditon
select * from emp,dept;
emp having 10 rec
dept having 5 rec
out == 50 rec
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / kannan
when you assign key ={} these is called cartesian join
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / riman bhaumik
its not like --with out condition...
TABLE 1 Table 2
X Y X Z
a e a j
b f a k
c g i m
Resultant Join over field X
X Y Z
a e j
a e k
This is an example of Cartesian joins.
| Is This Answer Correct ? | 3 Yes | 6 No |
How to move or copy the project parameter or project object to my sandbox?
How many components in your most complicated graph?
Have you eveer encountered an error called "depth not equal"?
i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.
What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox?
5 Answers JPMorgan Chase, Syntel,
What kind of layouts does abinitio support?
What are the various types of layout supported by abinitio?
What is use of creating a save files? How to use in abinitio graph?
1 Answers Cognizant, IBM, Intellego, TCL,
What is standard environment ?
How to add default rules in transformer?
What are the different String functions used in Abinitio?
Tell us about the architecture of abinitio.