Interested to Buy Any Domain ? << Click Here >> for more details...
What are Cartesian joins?
- 3 Answers
- 11506 Views
- I also Faced
- E-Mail Answers
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 differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?
what is the difference between the .dbc and .cfg extensions and give any clear information ?
. How can you run a graph continuously without using continuous components ?
) Diff.between Output index and Output indexes?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
. What is dynamic lookup ?
How can you force the optimizer to use a particular index?
What information is provided by .dbc file extension for connecting to the database?
What is AB_LOCAL expression where do you use it in ab- initio?
How Does MAXCORE works?
What are the Graph parameter?
What are the Types of parallelism in detail?
Teradata 
