Hi
I have incorrectly posted the warning message in server edition.
Previously I was getting the following warning.
Ignoring duplicate entry at table record 2; no further warnings will be issued for this table .
I have solved the warning by
allow duplicates in the appropriate lookup fileset
I am having 2 problems now
when I use this lookup filesets as a lookup in main job , in the drop down list the link names does not exist and also i am getting the following error
LKP_AR_X_IP,0: Multiple lookup tables allow duplicate entries: 0 (d:\dsfiles\LKPFS_AR_NM) and 1 (d:\dsfiles\LKPFS_IP_NM).
Kindly let me know where I am going wrong.
Regards
prabu
Error using lookupfilsets
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're not necesarily going wrong. DataStage is simply letting you know that there are dupllicates, and what it's doing with them (ignoring them, so that you only get one row returned, from a reference input link for example).
You can use a message handler to demote the warning message to informational if that's your concern.
You can use a message handler to demote the warning message to informational if that's your concern.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.