Sparse lookup is equivalent to which job

[major]

Hi,

A silly one but is sparse lookup equivalent to Inner join or Left outer join ? I can do a POC and find out but I'm away from PC for couple of days

Thanks
Major

[ray.wurlod]

Depends on your Lookup Failed rule:

• if Continue, then you're implementing a left outer join
  
  if Drop, then you're implementing an inner join

[major]

Thanks Ray , thought so.