Inner Join

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)?

Questions by puneetdking   answers by puneetdking

Showing Answers 1 - 4 of 4 Answers

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 is depending on the transform what you given.

suppose if you have
in0: 1,1 (one record)
in1: 1,1,1
1,1,2 (two record)

with no key that will give you 1 cross 2 -----> that results in two records in out port.

Hope this will clarify your doubt/

Thanks.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions