Interested to Buy Any Domain ? << Click Here >> for more details...
What are Cartesian joins?
- 3 Answers
- 11641 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 |
Order of Evaluation of Parameters
)what is wrapper script?where it is going to execute and why we go for wrapper?
What are the co> operating system’s assorted library of integrated components?
What is de-partition in abinitio?
Explain data flow graph with an example?
What is the difference between dml expression and xfr expression?
Have you ever encountered an error called “depth not equal”?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
Why might the optimizer use a table scan when an index is available?
What is standard environment ? How to use in abinitio graph?
Hi friends if u don't mind i want one question What abt READ MULTIFILE COMPONENT? PLZ GIVE BRIEFLY?
What are the facts that can compromise data integrity?
Teradata 
