DSXchange

priyadarshikunal already showed you how to remove the warnings.

RCP is usually set on the Output properties, Columns tab.

ray.wurlod wrote:priyadarshikunal already showed you how to remove the warnings.

RCP is usually set on the Output properties, Columns tab. ...

what should I do for the RCP do i need to change it in the stages?

and the other warning is the sort stage....could you tell me what can i do....the
warning is in my previous posts..

thanks,
Rahul

priyadarshikunal already showed you how to remove the warnings.

datastage by default inserts a sort check before remove duplicate stage and that default operator expects the data to be sorted in ascending order. The time you change the sort order to ascending the warning will disappear but you need to be careful as changing the sort order may lead to incorrect results.

so first check the requirements before you do anything.

priyadarshikunal wrote:datastage by default inserts a sort check before remove duplicate stage and that default operator expects the data to be sorted in ascending order. The time you change the sort order to ascending the warning will disappear but you need to be careful as changing the sort order may lead to incorrect results.

so first check the requirements before you do anything.

Thank you kunal,
I got rid of some warnings due to the ascending order but I get an extra column in my output is there any way to get rid of it,

and My other warning is of RCP as you said how do I get rid of it ...?

thanks,
rahul

Go back, read all the advice carefully. Everything you need to do is already in this thread.