Anusha Namburu (AnushaNT)
Tech Mahindra

Tech Mahindra
AnushaNT Member since 2015 2 posts
Tech Mahindra
Posted: May 5, 2016
Last activity: May 6, 2016
Posted: 5 May 2016 17:40 EDT
Last activity: 6 May 2016 12:19 EDT

How to generate a unique id for an external table

Hi All,

I have a data class in Pega for which there is an external table in Pega DB. Every time a record is inserted into the table, I need to have a unique id for the record. Can anyone tell me how to accomplish this requirement?

There is OOTB GenerateID activity which looks for the highest ID in the table and fetches the ID for the work objects, but I have to embed this logic in file processing. After parsing each record in the file I need to insert the same data into a table and there will be millions of records. So using an activity with Java step might impact the performance

Please provide your suggestions.


Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.