Scenario: ORA-00942 table or view does not exist

Real Scenraio 1:

Q: ORA-00942: table or view does not exist

Answer:   when we are getting this type of errors in Informatica we need to check the below two scenario's.

** first we need to check the particular schema which is mentioned infront of the tablename. whether it is exsted in the Database or not?

*** if the Schema ia existed, then we need to check whether the table is existed in the database or not?

Example: suppose the below Query was failed when i ran this quey in XYZ Database.

select * from A.EXAMPLE;

i am getting the below error:

ORA-00942: table or view does not exist.

so first we need to check Schema A is existed in XYZ Db or not?

second we need to check EXAMPLE Table is existed in A Schema in XYZ Databse or not?

Thanks,

Anilkumar.