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!

Invalid Identifier Error in Column

rosy91Sep 25 2012 — edited Sep 25 2012

Hi All,

I am using ODI 11.6 and Oracle 11.

I am doing Flat file to table mapping...

I am facing the below error..

ODI-1228: Task INT_XLL_FFT_TMP (Integration) fails on the target ORACLE connection EDGE.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00904: "SA"."LNAME": invalid identifier.

It fails in Insert new rows step...I am using LKM file to oracle

Please let =me know how to resolve this.

Thanks,
Lony

This post has been answered by Bhabani Ranjan Mahapatra on Sep 25 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2012

Added on Sep 25 2012

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

9 comments

1,671 views