Full Load Data Warehouse (DWH) Job fails with the below error.
Error ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_ODF_Z_TEST. column "column_name" is of type numeric but expression is of type character varying
Caused by changing the type of the attribute from string to numeric without unchecking it for DWH and re-running the load DWH job.
Release : 15.9.2
Component : Clarity Data Warehouse (DWH)
See also: Data Warehouse (DWH) known issues