Question
Read the adaptive predictors from the BLOB
Hi Team,
We have a requirement to get the data from five tables linked to a single customer class. Once we get the records, we need to process the adaptive model on the customer data.
1. We cannot create one dedicated table with all the predictor columns(coming from 5 tables). As we have around 500+ predictors.
2. We cannot create a data base view to create the dynamic snap shot of the customer data.
Approach(Want to know the design impact): Get all the predictors into one BLOB column. That means I have a table with two columns one with CustomerID*, BLOB. Can we get the predictors from the BLOB column in order to run the adaptive models? If yes, what will the performance impact of having 500+ predictors reading from the BLOB.
Regards,
Nizam
As far as I'm aware, custom blob are not supported:
https://pdn.pega.com/support-articles/unable-save-attachments-pega-different-table
So for this approach, you would need to leverage the Pega blob. For example, you create a new class with CustomerID (exposed) and a value list or value group property (storing all these predictors, not exposed).
This way these predictor ends up in the Pega blob.
If you read only 1 records, then I expect performance impact won't be huge. After all, a simple case opened by Pega using the Pega blob contains often hundred of data element if we count all the date in pages, page list, page grounp embedded in the case.
If you read many records at the same time, then it will be felt. This is why reports needs to run against exposed properly (and not the blob).