Sparse Lookup returning multiple rows

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Sparse Lookup returning multiple rows

Post by meriem_ens »

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
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

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

Mike
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Post by meriem_ens »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
meriem_ens
Participant
Posts: 30
Joined: Thu Jun 06, 2013 9:12 am

Post by meriem_ens »

This is not a good news. thanks
Post Reply