Series: Subject: Topic:
Question: 13 of 236

# 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)?
Asked by: puneetdking | Member Since Sep-2011 | Asked on: Sep 22nd, 2011
Showing Answers 1 - 4 of 4 Answers
puneetdking

Answered On : Sep 28th, 2011

when i tried on abinitio tool the above situation, i got 1 record in output file.. can you explain how?

1 User has rated as useful.

hemanth.pesce

Answered On : Sep 29th, 2011

View all answers by hemanth.pesce

you will get 1.

P N Reddy

Answered On : 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.

vijayv

Answered On : 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

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