1 2 Previous Next 15 Replies Latest reply on Feb 28, 2013 5:13 AM by Phanikanth Go to original post
      • 15. Re: IKM Oracle Incremetal Update(Merge) not handling Duplicate records
        Phanikanth
        HI Bhabani,

        I have tried below one and it is working,

        Below table created at source DB,

        create table ODI_JOB_EXECUTION_DETAILS (
        SESSION_NO VARCHAR2(30) PRIMARY KEY,
        SCENARIO_NAME VARCHAR2(100),
        CONTEXT_NAME VARCHAR2(20),
        ERR_MESSAGE CLOB,
        INSERT_COUNT VARCHAR2(10),
        ERROR_COUNT VARCHAR2(10)
        );

        Created ODI procedure Technology=oracle>Schema=my source DB schema>I checked the ignore errors and command source added below code and I have test it is working
        begin
        insert into ODI_JOB_EXECUTION_DETAILS values
        (
        <%=snpRef.getSession("SESS_NO")%>,
        '<%=odiRef.getPrevStepLog("STEP_NAME")%>',
        '<%=odiRef.getContext( "CTX_NAME" )%>',
        '<%=odiRef.getPrevStepLog("MESSAGE")%>',
        '<%=odiRef.getPrevStepLog("INSERT_COUNT")%>',
        '<%=odiRef.getPrevStepLog("ERROR_COUNT")%>'
        );
        commit;
        end;


        Regards,
        Phanikanth
        1 2 Previous Next