Question

5
Replies
1236
Views
Close popover
Manish Kumar (ManishBhateja1)
HAP

HAP
US
ManishBhateja1 Member since 2015 9 posts
HAP
Posted: January 29, 2018
Last activity: February 22, 2018
Closed
Solved

Column Populator utility alternative

For 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
Moderation Team has archived post