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 |
What are the types of data processing you are familiar with?
What is the difference between sandbox and EME?
How scientific data processing is different from commercial data processing?
What are the different types of parallelism in ab initio?
Mention what dedup-component and replicate component does?
What is rollup component?
What is the function you would use to transfer a string into a decimal?
State the working process of decimal_strip function?
What is the DynamicScriptGeneration and what is the Use?
How to run a graph infinitely?
Explain what does dependency analysis mean in abinitio?
Explain what is sort component in abinitio?