Read the adaptive predictors from the BLOB
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.