Hi Sangeeta,

What version of datastage you are using.

if it 7.5.1a then there is no sorragate key generator, so we need to use stage variable, so that it generate maually every time you insert...