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
keyMgtGetNextValue
Moderators: chulett, rschirm, roy
Thanks for the reply Craig.chulett wrote:Yes, but with the 'multiple jobs, same table, same time' requirement, make sure you use the 'Concurrent' version. ...
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.