Hello, I get this error message when I try to view the data from my source tables: ORA-00942: table or view does not exist.
My source tables are stored in an excel file as workbooks and each workbook is a table under an ODBC module.
I could see them before, but now I cannot.
Can you please help me, because I work on oracle and data warehouse for first time and I don't know what to do.
Message was edited by: 931546
You have to figure out why you could see them before...and now you cannot. Something has changed somewhere. Check the source db, check the gateway, check the credentials and connection info in OWB, something is different.