Custom error table
Hi ODI guru's,
I have few questions about my ODI requirement.
As per the requirement I have to load data from one oracle table to another. All successfully inserted records should get deleted from source table. If there is any error (constraint violation) occurs that should be recording in source table. I have few columns (error_status,error_message etc) defined in source table for error.
By requirement it looks like I need not to use E$ tables to store error information but I need to use a custom table (source table) to store error record.
What could be the best way to achieve it?
What if I right click on target table in Model and select 'Error...' to view error records. I don't think it will show errors from custom table. Is there any way I can achieve it?
Thanks
Sanjeev.