Error using lookupfilsets

praburaj · Post by **praburaj** » Wed Apr 12, 2006 7:01 am

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

kumar_s · Post by **kumar_s** » Wed Apr 12, 2006 7:09 am

What do you mean by link name dropdown list? Is it 'Input name' in the Input tab. Are you sure you have connected properly the linkt to the lookup stage?

praburaj · Post by **praburaj** » Wed Apr 12, 2006 7:48 am

In the lookup if u go to the condition page(ie where u give the lookup condition if u go to that page u can see the drop down list

kumar_s · Post by **kumar_s** » Wed Apr 12, 2006 7:59 am

Do you mean 'Multiple rows returnd from link'?
If so, this is enable only for reference link.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 12, 2006 4:16 pm

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.