What will be output for Inner join having no key when I/P in two respective Input Ports are:- Input1 = 1,1 (one record with two fields) Input2 = 1,1,1 (one record with three fields)?

vijayv

 Profile Answers by vijayv Questions by vijayv

• Feb 3rd, 2012

Yes, this is wonderful scenario.
in0:1,1
in1:1,1,2
when we are using inner join wil get 4 records
(1,1)(1,1)(1,1)(1,1).
when we are using cartesian join (with out key) wil get 6 records.
i.e. 2 X 3 records....(1,1)(1,1)(1,2)(1,1)(1,1)(1,2) records.
Thank you

P N Reddy

• Jan 12th, 2012

Yes you will get only one record when you have not given any key in join that will give you the cartisean product. since you have the inputs as in0-1record and ina-1record 1 cross 1 is 1. the output ...

Answer Question  Select Best Answer