Warning when I use lookup fileset

bala_135 · Post by **bala_135** » Thu Mar 09, 2006 7:26 am

Hi,

I am a using lookupfileset which has date and time values.I am using the field SRC_STM_ID as the key field to get the values.When I do that data is prpogating but i am getting the below mentiooned warning.

LKP_CL: When checking operator: Dropping component "SRC_STM_ID" because of prior component with same name.

1.Tried disabling the RCP for this.
2.changed the column name in the output of the lookupstage.
3.Used Copy stage and renamed.

but could not suceed.

Kindly give me some outputs so that I can try on those lines to the problem.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 09, 2006 11:22 am

This is a warning that can safely be demoted to informational. It's telling you that the key column passed to the Lookup File Set is exactly the same as the key column returned from the Lookup File Set, so one of them has been consumed so that only one of the (identical) values is moved onto the output link.

DSguru2B · Post by **DSguru2B** » Thu Mar 09, 2006 11:53 am

Check the nullability of the columns. Sometimes if one is nullable and the other is not, then usually warnings such as this are given too.