Question

3
Replies
5121
Views
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
Share this page LinkedIn