keyMgtGetNextValue

[naren6876]

Hi All,

I am loading the same tables from different jobs at the same time.right now, i am using the database sequence and which is executing millions of times and that is overhead to the process now.

So, can i use the keyMgtGetNextValue sdk routine/transform to generate the surrogate key?

Please advice.

Thanks,
Naren

[chulett]

Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version.

[naren6876]

Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version. ...

Thanks for the reply Craig.

I need to generate multiple sequence numbers for multiple tables withing the same job.

And the above mentioned sdk has argument called 'SequenceName'.

could you please guide me how to generate this Sequence's for multiple tables.

Thanks,
Naren.

[chulett]

You will get a sequence generated for every unique 'name' you pass in. I generally use the target table (or sequence) name.