Load DW Fails Invalid Identifier - Reserved word
Article ID: 107525
Clarity PPM SaaS
Clarity PPM On Premise
Load DWH job failing with error:
Invalid Identifier at:
ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)
Note the lookup ID is INDEX.
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
The lookup was using the reserved word INDEX.
Create a calculated attribute as a string to pull in the existing data from the original attribute and use that attribute in the data warehouse.