Code: Select all
Error message: ORA-00904: "FACT_SLS"."ROWID": invalid identifier
Change Oracle Connector's property 'Table name for partitioned reads' to specify both the 'Table name' and 'Alias'.
i.e. If FROM clause of the SQL executed in Oracle Connector is FROM EDW.FACT_SLS FS and in DataStage 9.12, value of 'Table name for partitioned reads' is EDW.FACT_SLS, then in 11.5.0.1 it needs to be changed to EDW.FACT_SLS FS