Full Load DWH Job fails with 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-run the load job.
Release : 15.9.2
1. Uncheck include in DWH for the attribute which needs to be changed to a different data type.
2. Run the full DWH load.
3. Create the attribute with the new data type and include it for DWH.
4. Run the full DWH load.