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!

URGENT:how to get the error table populated in ODI

964827Oct 10 2012 — edited Oct 17 2012

Hello all,

I am working on an interface of ODI where mapping is from a XML file to the database tables. I want, when there is any bad data (having length size greater than the target table's column length or data type mismatch) the bad data should get rejected or separated.

I am using LKM, CKM, and IKM knowledge modules, but the erroneous record is not getting populated in even in the error table.

when I try to insert lets say 4 records and 2nd record is erroneous then it is only inserting the 1st record. i want that the erroneous record should get inserted in the error table.

Please suggest, if anybody is having any related information to get this done. That would be really helpful.

Thanks in advance!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2012

Added on Oct 10 2012

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

7 comments

748 views