DSXchange

Hi Siva, thanks very much for this ! I had similar findings after a few more tries :mrgreen: KeyMgt functions was identified to be the blocker after adding debug params and disabling other transforms...I was pretty shocked to find that - initially I was suspecting CRC32 or stage variable calculation...

In developing an upsert job, I tried KeyMgt functions to assign surrogate keys to a sequence file and output SKs and rest of the data to another sequence file...then load that into Oracle DB. Surprisingly, I found that KeyMgtGetNextValue gets 24 row/sec and KeyMgtGetNextValueConcurrent gets 12 row/s...