DSXchange

Posted: **Mon Nov 10, 2014 5:54 pm**

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

Posted: **Mon Nov 10, 2014 9:53 pm**

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

Posted: **Thu Nov 20, 2014 4:08 pm**

Thanks Ray , thought so.

DSXchange

Sparse lookup is equivalent to which job

Sparse lookup is equivalent to which job