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!

Getting records into Error Table

988115May 29 2013 — edited May 31 2013

Hi all,

I am having 2 tables namely student and master in my source of interface. Need to validate data such that the student table data which matches with master table data should load into the target and the unmatched data from student table should be sent to an error table. The validations needs to be performed on columns sid, fname, lname and dob which are present in both the tables. Please help me how to achieve it.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2013

Added on May 29 2013

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

3 comments

194 views