After upgrading Clarity to 15.9.3 or newer versions, the DWH jobs may fail with an error:
Process Meta Tables - ERROR: ENCOUNTERED EXCEPTION WHILE CREATING VIEW DWH_TRD_INV_INVESTMENT. column dwh_inv_investment.risk_score does not exist
Release : 15.9.3, 16.0.0
risk_score is a new column introduced to the Investment object beginning in 15.9.3.
If this error occurs, the Data Warehouse job should be run, using the Full load options.