Column Optimization in Pega

 Column Optimization in Pega

Hi Friends, Now in this post we will try to optimize column “CustomerID” in Build-BuildApp-Work-Cusomter Class. Optimization is Otherwise called Column Expose.

Before Optimization CustomerID Column is not available in DB Table.

To Optimize Property right click on the property name in App explorer and select Optimize for reporting.

Selected Population Schedule as Now.

What is Column Population?

 Consider a scenario, we already processed 100 cases for that records customerid is available in blob.

For new cases only customerid will populate in newly created column(CustomerID). We have to copy CustomerID from blob to Newly created column for existing cases . Copying that existing data from blob to new column is called Column Population.

Wizard Screen 2: Click Next.

Wizard Screen 3: Click Finish or Click Column Population Jobs Dashboard to know progress of Column Population.

Column Population Dash Board.

ScreenShot 1:

Screen Shot 2:

We can see here for one instance data is copied from blob to new column. And it is completed.

When we check the DB table we can able to see the Column Name(CustomerID) and its corresponding value.