Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection

Maverick439May 24 2013 — edited May 24 2013

Hi all. I am using ODI for the first time. Trying to import a flat file data into Oracle table.
Flat file has 4 columns Empno,Ename,Deptno,Salary [2 rows]
so is the Target Table in Oracle [All are VARCHAR2 data type] --Empty table

I am using these KMs: CKM Oracle , IKM SQL CONTROL APPEND, LKM FILE TO SQL.

When I execute this Interface, it fails with the following error message:

ODI-1228: Task SrcSet0 (Loading) fails on the target ORACLE connection [Connection_Name]
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

I checked the Code and Source Code is null , Target Code is: Create Table schema.Load_{table_name} ( )

With no columns in it.

Can anyone help? I am using Oracle ODI 11G (11.1.1)

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 21 2013

Added on May 24 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

8 comments

2,498 views