Dynamic number

[diogo.cwb]

Hi all,

I must insert on my table an dynamic number called by PROCESS_NUMBER. So this number must be different each time i run my DS job.

Any idea ?

[priyadarshikunal]

"Generate surrogate key".

If this is not the answer you expected, Frame your question properly

[Sainath.Srinivasan]

You can fetch the OS process number of the process leader.

Best way is to hold and external control table and populate it with job run information.

[diogo.cwb]

Can't i make an Oracle stage to select max(PROCESS_ID) and on Transformer i increase +1 ?

[priyadarshikunal]

there are number of ways to do it if you just want a unique process number to be populated in to target.

One of them is like you mentioned.
you can select max(process_number)+1 as process_number and feed it to your input record.

[diogo.cwb]

ok. but tis solution doesn't increase my number each row ? because i don't want it.

[Sainath.Srinivasan]

As long as you do not change the PROCESS_NUMBER column in the table it is max() from, the value will remain same.

In other words, commit the max(PROCESS_NUMBER) + 1 back in the table after successful completion of current run.

If it is from the same target table where you are loading the rows, then extract the value into an hash file or something similar. That way you avoid referring your target table.

[priyadarshikunal]

It will be a static value for the job unless you change it. If you want to be constant for all jobs for a perticular then get the value in sequence and pass it to all the jobs as parameter or store it in sequential file or hashed file and use it in jobs.

[diogo.cwb]

OK Thank's for all.