Question

3
Replies
5184
Views
Close popover
Anusha Namburu (AnushaNT)
Tech Mahindra

Tech Mahindra
US
AnushaNT Member since 2015 2 posts
Tech Mahindra
Posted: May 5, 2016
Last activity: May 6, 2016
Closed

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.

Thanks

Data Integration
Moderation Team has archived post,
Close popover 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.