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?