DSXchange

how to add sequence number for Existing primary key field for uniqueness
for Example :

181DAC246 + start with the sequence 0001 to every record

181DAC246 +0001
181DAC247 +0002
thank you

Look into surrogate key generator. Search the forums. It has been discussed before.

You mean concatenate, not add - yes? If so, generate the number and use the colon (:) concatenation operator to stick them together. Perhaps you need a surrogate key generated, perhaps it just needs to be the @INROWNUM. You'd have to tell us.

Is the base number hexadecimal and you wish to add, or is it the leading digits to which you want to append a four digit sequence number? Should the sequence number be hexadecimal or decimal?

Have a look at the FAQ forum on generating a unique counter in a parallel job. The surrogate key stage wont let you do a complex increment, a parallel transformer will. You need to use the parallel macros for partition numbers to make sure numbers are unique between parallel instances of the transformer.

yes, it is concatenate in Datastage 7.x server job. @inrownum giving the variable length number 1,2,...10,....100 etc. I need a fixed 4 digit length like 0001...0010,..0100,..etc.

FirstPart : Fmt(@INROWNUM, "R%4")