Analytics Software

Hi Friends,

I am using ODI 11g.

I am facing a error while working on XML to ORACLE mapping,

My source table name is Employee and Target table name is Copy Of Employee.I dont hv any join condition.

ORA-00942: table or view does not exist
and

select SYS_GUID(),
2883011,
rowid,
'F',
*'ODI-15065: Join error (TABLE__EMPLOYEE) between the table Copy of EMPLOYEE and the table TABLE_.',*
* sysdate,*
* '(237011)ODI_Test.INT_XML_TEST',*
* 'TABLE__EMPLOYEE',* 'FK',
EMPLOYEEORDER,
EMPLOYEE_KEY,
EMPLOYEE_KEYORDER,
HIRE_DT,
HIRE_DTORDER,
MGR_ID,
MGR_IDORDER,
MGR_NAME,
MGR_NAMEORDER,
NAME,
NAMEORDER,
POSTN,
POSTNORDER,
SVISOR_ID,
SVISOR_IDORDER,
SVISOR_NAME,
SVISOR_NAMEORDER,
TABLE_FK,
TYPE_,
TYPE_ORDER

from EDGE_DEV_OWNER."I$_Copy of EMPLOYEE" EMPLOYEE
where (
EMPLOYEE.TABLE_FK
) not in (
select TABLE_PK
from EDGE_DEV_OWNER.TABLE_
)
and (
EMPLOYEE.TABLE_FK is not null
)

Please suggest how to resolve this.

Thanks,
Lony