Question5Replies1236Views×Close popoverManish Kumar (ManishBhateja1) HAP HAP US View Profile ManishBhateja1 Member since 2015 9 posts HAP Posted: January 29, 2018Last activity: February 22, 2018Posted: 29 Jan 2018 11:52 ESTLast activity: 22 Feb 2018 4:03 EST Closed Solved Column Populator utility alternativeFor some reasons, column populator utility is not successful in our environment. We are working on it through a Pega SR. But my question here is on an alternative approach.If we expose a new column, say ColumnA, in our work table, can we use a simple update query like below to populate the column values?Update <WorkTable> Set ColumnA = pr_read_from_stream('.ColumnA', pzInsKey, pzPVStream) We can also control the magnitude using 'where' clause on create date column. Does column populator utility does something extra which we may lose by following query approach? Data Integration SR Created ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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. Posted: 2 years agoPosted: 29 Jan 2018 12:29 EST×Close popoverVikash Ranjan Karn (Vikash Karn) PEGA Senior Technical Solutions Engineer Pegasystems Inc. IN View ProfileVikash Karn PEGA replied to ManishBhateja1Hi Manish, One option is that you can optimize the respective property in your work table. This will automatically populate the data in the table. Other option that you can try is use BIX to extract the data in another DB table and then you can copy the data from this table to the exposed column of your work table. Regards, Vikash Posted: 2 years agoPosted: 29 Jan 2018 12:41 EST×Close popoverManish Kumar (ManishBhateja1) HAP HAP US View ProfileManishBhateja1 HAP replied to Vikash KarnThanks Vikas for your thoughts on this one. Option 1 is not applicable to Production environment. Considering Production would have millions of records, I think its better not to do it using optimize wizard. Option 2 seems good, however this will also do similar thing as I have mentioned in my option. Do you see anything wrong with the query I mentioned in the post? Again, I really appreciate your thoughts on this one. Posted: 2 years agoPosted: 29 Jan 2018 13:22 EST×Close popoverMarissa Rogers (MarissaRogers) MOD Senior Community Moderator Pegasystems Inc. US View ProfileMarissaRogers MOD replied to ManishBhateja1Hi @ManishBhateja1, Could you please share your SR ID so that we may link this with it? Thanks! Posted: 2 years agoUpdated: 2 years agoPosted: 29 Jan 2018 13:40 ESTUpdated: 30 Jan 2018 5:19 EST×Close popoverManish Kumar (ManishBhateja1) HAP HAP US View ProfileManishBhateja1 HAP replied to MarissaRogersIt's SR-C8179 Accepted Solution Posted: 2 years agoUpdated: 2 years agoPosted: 22 Feb 2018 3:46 ESTUpdated: 22 Feb 2018 4:02 EST×Close popoverRajendraprasadu Potti (Prajendra) PEGA Technical Lead Pegasystems Inc. IN View ProfilePrajendra PEGA replied to ManishBhateja1PRPC recommends below two approaches to populate the values for explicit columns. Populating database columns using the column populator . Refer following article for more details https://pdn.pega.com/sites/pdn.pega.com/files/help_v72/procomhelpmain.htm#engine/database/tools/eng-cp-running-tsk.htm Populating database columns by using the service enabled column populator utility. Refer following articles for more details https://pdn.pega.com/sites/pdn.pega.com/files/help_v73/procomhelpmain.htm#sys mgmt/sm-automated-expose-tsk.htm You can follow either of above approaches.