Skip to Main Content

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!

ODI : How to delete existing records instead of update in odi Interface

2815110Dec 16 2014 — edited Dec 22 2014

I am new to ODI. I have a source table STAGE_GLCOA_SYN and the target table FIF_GL_CROSS_REF.

Current Logic : identify the record is new /existing record in the target (FIF_GLCROSS_REF) if new then insert else update

New logic — identify the record is new /existing record in the target (FIF_GLCROSS_REF) if new then insert else if record exists then delete the old record and insert the new set

How to achieve this? Is there any option in KMs to delete the existing record and then insert or do I need to add a procedure for this?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 19 2015
Added on Dec 16 2014
4 comments
879 views