DSXchange

Hi All


there are 10 columns in my target table,
9 columns are filled from source
and 10th column needs to be filled by number sequence starting from 1

eg for load 1
for 100 records, the 10th column is populated as 1 thorugh 100

eg for load 2
for 100 records, the 10th column is populated as 101 thorugh 200

the job is parallel job

src:table/file
tgt:table

can anyone help me,
thanks in advance

Thanks
Suresh

Sure, but you can help yourself faster by searching.

Essentially what you need to do is as follows (in a job sequence).

• Determine the current maximum value (use a job).
  
  Load this somewhere convenient (a file, or the job's user status area).
  
  Retrieve that value.
  
  Use that value as a job parameter to provide the starting value of your numeric sequence.
  
  Use system variables (such as @PARTNUM, @PARTCOUNT) to generate a sequence of unique numbers irrespective of the degree of parallelism in your main job.

Suresh,

you can use oracle sequence and use a lookup stage in your job perform sparse lookup on oracle sequence and get the next value each time for each record.

Something wrong with using the Surrogate Key stage?

can you please elaborate it

thanks
suresh

Hi Deepak Can you please elaborate it

thanks
sai