Question
Tata Consultancy Services
IN
Last activity: 15 Sep 2023 14:03 EDT
Unexposed Property Column Population job
Hi Team,
Please find the below queries,
We are facing unexposed property issue in prod during Pega upgrade. Now we are trying to expose the column in Work table but in prod we are having more than one Billions of records which is impacting 50% of the rows present in Work table. Example: We are having Table: ICIC-FW-ABC-Work-XYZ Table which is having unexposed property "EarliestNIDate" now we need to expose this property. But in Production we are having more than 1 Billion of records present and this expose property will impact the Work Table 50% only and application performance will be impacted if we add it in work table. So we are approaching with the solution of creating a temp table instead of Work eg: ICIC-FW-ABC-Work-XYZ which is having the "EarliestNIDate" data in the Blob. we will add the property "EarliestNIDate" in this table ICIC-FW-ABC-Data-PQR and we will add the join conditions for these tables. Now, Instead of writing one time Utility to copy the blob data we are checking whether column population job is possible or not.
If Column population Job is possible then,
1) We need to copy the blob data to the BNPP-FW-ABC-Data-PQR table.
-> for performing this please provide us the Steps or procedure Document that needs to be taken care from DB team end.
Hi Team,
Please find the below queries,
We are facing unexposed property issue in prod during Pega upgrade. Now we are trying to expose the column in Work table but in prod we are having more than one Billions of records which is impacting 50% of the rows present in Work table. Example: We are having Table: ICIC-FW-ABC-Work-XYZ Table which is having unexposed property "EarliestNIDate" now we need to expose this property. But in Production we are having more than 1 Billion of records present and this expose property will impact the Work Table 50% only and application performance will be impacted if we add it in work table. So we are approaching with the solution of creating a temp table instead of Work eg: ICIC-FW-ABC-Work-XYZ which is having the "EarliestNIDate" data in the Blob. we will add the property "EarliestNIDate" in this table ICIC-FW-ABC-Data-PQR and we will add the join conditions for these tables. Now, Instead of writing one time Utility to copy the blob data we are checking whether column population job is possible or not.
If Column population Job is possible then,
1) We need to copy the blob data to the BNPP-FW-ABC-Data-PQR table.
-> for performing this please provide us the Steps or procedure Document that needs to be taken care from DB team end.
2) Also please confirm us whether the Blob data will be present in both BNPP-FW-ABC-Work-XYZ table and BNPP-FW-ABC-Data-PQR table after performing column population job?
Please guide us in this. please do the needful.
Thanks,
Keerthana.M.D
Infosys
IN
The column population job or prpcServiceUtils method happens on the same table , not from one table to another . For your requirement I suppose you might have to create a Utility that
1. Loops
2. Opens blob data and populates the data in another table
But this can be an extensive activity if you have many cases therefore good to perform in Off Business hours
Pegasystems Inc.
CA
We're duplicating the information from Work to Data. Again, join to the data table will cause severe performance impacts considering billions of cases.
Column Population job is meant for the same table - populating the exposed column with the information stored in the blob. For example: ProductType is stored in the blob. Now you expose the ProductType property, so there will be a new column in the database table. Then run the column population to populate the data in the ProductType column for the inflight cases.
Thanks,