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
Sparse Lookup returning multiple rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Thu Jun 06, 2013 9:12 am
-
- Participant
- Posts: 30
- Joined: Thu Jun 06, 2013 9:12 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 30
- Joined: Thu Jun 06, 2013 9:12 am