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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Issue with IKM SQL Control Append after migration from 11g to 12c

Hitesh BajoriaAug 27 2020

Hello,

We are currently working on the migration of our code from ODI 11.1.1.9 version to ODI 12.2.1.4 version.

We have one custom IKM written in 11g which appends the session ID to C$ table name. The same piece of code is working differently in 12c.

1. It is generating an Alias Name for the C$ table

2. Session id is getting appended to the Alias Name instead of C$ table name

The code is:

insert into          <%=odiRef.getTable("L","TARG_NAME","A")%>

(

              <%=odiRef.getColList("", "[COL_NAME]", ",\n\t", "", "((INS and !TRG) and REW)")%>

              <%=odiRef.getColList(",", "[COL_NAME]", ",\n\t", "", "((INS and TRG) and REW)")%>

)

select

    <%=odiRef.getColList("", "[COL_NAME]", ",\n\t", "", "((INS and !TRG) and REW)")%>  

  <%=odiRef.getColList(",", "[EXPRESSION]", ",\n\t", "", "((INS and TRG) and REW)")%>

FROM (

<%for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){%>

<%=odiRef.getDataSet(i, "Operator")%>

select    <%=odiRef.getPop("DISTINCT_ROWS")%>

        <%=odiRef.getColList(i,"", "[EXPRESSION] [COL_NAME]", ",\n\t", "", "((INS and !TRG) and REW)")%>

from     <%=odiRef.getFrom(i)%>#P_SESSION_ID

where   <% if (odiRef.getDataSet(i, "HAS_JRN").equals("1")) { %>

              JRN_FLAG <> 'D'              <%} else {%>      (1=1)     <% } %>

<%=odiRef.getJoin(i)%>

<%=odiRef.getFilter(i)%>

<%=odiRef.getJrnFilter(i)%>

<%=odiRef.getGrpBy(i)%>

<%=odiRef.getHaving(i)%>

<%}%>

) <%=odiRef.getInfo("DEST_TAB_ALIAS_WORD")%> ODI_GET_FROM

Do we know if its a bug or code needs some modification to work as it's working in 11g version.

Thanks

Comments

SiatGesi Feb 14 2025

THE FIRST problem howto wrap I have resolved…

SiatGesi Feb 14 2025

now I'm trying to move the unzipped files (pictures) from db to AS… my real problem… best regards

1 - 2

Post Details