Lakshmi B T

• May 2nd, 2006

 

a left semi-join on two input files, connected to ports in0 and in1 is the  Inner Join .The dedup0 parameter is set to Do not dedup this input, but dedup1 is set to Dedup this input before joining.

Duplicates were removed from only the in1 port, that is, from Input File 2.

K Nagi Reddy

• May 4th, 2006

 

semijoins can be achieved by using the join component with parameter

Join Type set to explicit join and the parameters recordrequired0,recordrequired1 set one to true and the other false depending on whether you require left outer or right outer join.

prabhupurna

 Profile Answers by prabhupurna Questions by prabhupurna

• Jul 6th, 2006

 

in abinitio,there are 3 types of join...

1.inner join.        2.outer join         and 3.semi join.

for inner join 'record_requiredn' parameter is true for all in ports.

for outer join it is false for all the in ports.

if u want the semi join u put 'record_requiredn' as true for the required component and false for other components..

jagan

• Nov 16th, 2011

 

A semi-join returns rows from one table that would join with another table without performing a complete join. It doesn't have explicit syntax.

Eg : semi join to evaluate an exists sub query

Code