DSXchange

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......

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.

Thanks!