Question
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?
Hi 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