Warning Problems in Join,Merge and Lookup

kondeti · Post by **kondeti** » Wed May 23, 2007 6:17 am

Hi All

I am getting the below warnings when i use Join,Merge and LookUp stages. From DataStage director we can supress these warning but i want to do the same in the job. Please guide me on this.

These are the warnings:

JOIN: When checking operator: Dropping component "MATERIAL_DOC_YEAR" because of a prior component with the same name

Merge_Customer: When checking operator: Dropping component "MSGFN" because of a prior component with the same name.

Lkp_Customer_Sales_Data: When checking operator: On output data set 0: Dropping component "MSGFN" because of a prior component with the same name.

Regards
Kondeti

DSguru2B · Post by **DSguru2B** » Wed May 23, 2007 7:25 am

Try to get rid of the warnings instead of demoting it. Search on the error message on the "How to".
As for message handling, you can only do it from the director. No method, that I know of, can demote the warning message within a job, other than in a modify stage using NOWARN, but thats for modify stage operators.

Maveric · Post by **Maveric** » Wed May 23, 2007 8:41 am

Try switching off the RCP in the join stage and run the job. This might help remove the warnings in join. Can try the same thing with the Lookup stage.

kondeti · Post by **kondeti** » Wed May 23, 2007 9:23 am

Thank you

dsedi · Post by **dsedi** » Wed May 23, 2007 9:34 am

This warning is due to the same column name on Join/lookup.
Check the field names on the links to the JOin/Lookup and renaming the names will get rid of the warning.

Regards,Edi

kondeti · Post by **kondeti** » Wed May 23, 2007 9:35 am

I didn't enable the RCP in the join Stage.