Interested to Buy Any Domain ? << Click Here >> for more details...
What are Cartesian joins?
- 3 Answers
- 11512 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 dedup-component and replicate component does?
Can you use scan to generate sequence number ? How to use in abinitio graph?
What are the co> operating system’s assorted library of integrated components?
how to insert/update a csv file by comparing it with another csv file?
Describe the grant/revoke ddl facility and how it is implemented?
) Diff.between Output index and Output indexes?
How to create repository in abinitio for stand alone system(local nt)?
What do you mean by data sorting?
What is abinitio?
What is the role of co-operating system in abinitio?
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?
Is there any function in ab Initio which act like SCAN component
Teradata 
