Load DW Fails Invalid Identifier - Reserved word
Document ID :
Last Modified Date :
Show Technical Document Details
CA PPM SAAS DATA WAREHOUSE:ODDWH
CA PPM DATA WAREHOUSE:PPMDWH
Load DWH job failing with error:
Invalid Identifier at:
ALTER TABLE DWH_LKP_INDEX ADD INDEX VARCHAR2(255)
Note the lookup ID is INDEX.
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.
for a complete list of Oracle Reserved Words
Was this information helpful?