Inner Join

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.

  

Login to rate this answer.

you will get 1.

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.

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