Skip to Main Content
Forums

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!

E$ tables in ODI

user10723402Aug 9 2012 — edited Aug 10 2012
Hi,

I have some 100K records in my I$ table. And the merge step fails with unique constraint violation error. There are some 2000 records which are coming in as dups as a result fialing with unique constraint violation error.

In such situations, I want to exclude these bad records into a temporary table and load the other records which do not have any viloations into the final target table.

How can I do this bypassing and loading of bad records into a temporary table?

Thanks in adavance.

Thanks,
San
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 7 2012
Added on Aug 9 2012
#business-intelligence-applications, #data-integrator, #system-management-and-integration
14 comments
1,510 views