DSXchange

Do we have any function for generating the sequence number in Oracle
in PX.

Thanks,

Be more specific. Are you referring to leveraging an Oracle sequence object, the kind of thing you would 'select x.nextval from dual' to use?

If so, why not just use the Surrogate Key Generator stage?

There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

Madhusv wrote:There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

The routines mentioned above will help you if you are on server edition.
If px, the follow Craig's advice. As both the advices are specific to the edition your working on.

DSguru2B wrote:

Madhusv wrote:There are routines KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, You can use this to genrate sequence in server jobs

The routines mentioned above will help you if you are on server edition.
If px, the follow Craig's advice. As both the advices are specific to the edition your working on.

I tried in server with the above two key translomations its working fine and I have used surrogatekey stage in PX it also worked fine.

Thanks for all your help

Watch this space.