DSXchange

Can anyone suggest an approach to what value should be given to start value in serrogate key generator stage in .we have need to take max value of key cloumn and increment from it

I think you will find that there's no such thing as a Surrogate Key Generator stage (however spelled) in DataStage TX. Please post any question you may have in the correct forum. You also need to be alert to the implications of running a job in parallel.

Thanks for ur gudence.I have to pose this issue in PX