Hello,
I have a following error in one of my jobs:
LKP_DIAGNOSIS_BRIDGE,0: Ignoring duplicate entry at table record 720; no further warnings will be issued for this table
I know what the error means, and can fix it, but the question I have is:
If there are several rows returned from a reference table with the same key value, is the lookup value at least picked up from one of those several rows, while of course ignoring the other rows in the set?
Thanks
Lookup warning-Ignoring duplicate entry at table record
Moderators: chulett, rschirm, roy
The warning message means that DataStage detected a duplicate key while building up the lookup table and only stored the first key and it's corresponding data values. When doing the lookup with actual data, only that value is in the table and therefore only that value is returned.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for the response.
As I mentioned, I know what the message means, and what I need to do to fix it. The question was, in case there are more than one row returned for lookup, as it did here, does DS ignore the lookup value, or it looks up the value from the first available reference row, and ignores the rest of the rows?
Of course, I can set up a simple test to verify.
As I mentioned, I know what the message means, and what I need to do to fix it. The question was, in case there are more than one row returned for lookup, as it did here, does DS ignore the lookup value, or it looks up the value from the first available reference row, and ignores the rest of the rows?
Of course, I can set up a simple test to verify.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: