Generating a number incrementally

[Nareshkotti]

Hi All,

My requirement is i will fetch some records using an odbc stage from a table and load in to another, every time i run the job i need to increment a field value.

For ex: i have field say SNO,

Now when i run the job for the first time then SNO should be populated with the value 1 , for the next run the SNO is incremented by 1..........

Can someone help me out......

Thanks in advance......

[ray.wurlod]

Fetch SNO from the target in another stream in your job, increment it and merge or join it into the main flow. Or use a separate job to extract and increment SNO and pass this value to the main job as a parameter.

[Nareshkotti]

Thanks!