DSXchange

Hi,

I have an issue where a sparse lookup is generating multiple rows even if the Multiple rows returned from link property is empty.

This is my job design

A first oracle connector (primary link) => 3 rows
A second oracle connector (reference link) - with the lookup type on sparse => 3 rows

The lookup is done on a single column (partitioning is on auto on the primary link). The reference table can return multiple rows.

The output of the lookup stage is 4 rows (there is a key that can return 2 rows).

I just don't understand why the lookup is generating 4 rows instead of 3.

Thanks

That property (Multiple rows returned from link) only applies to in-memory lookups.

Mike

Does this mean that when you do a sparse lookup it will always return multiple rows if the lookup condition is met several times ?

thanks

Yes.

This is not a good news. thanks