Hello, I migrate an odi11 IKM to ODI12. The code ist still the same but it delivered an other result.
This statement <%=odiRef.getSrcTablesList(i, "", "[TABLE_ALIAS]", ", ", "_X")%>
delivered on ODI11: BENNY.STBA
and in ODI12: BENNY.C$_0STBA STBA_A
Do anybody know this issue and how to solve it.
insert /*+ APPEND */ into <%=odiRef.getTable("TARG_NAME")%>
(
<%=odiRef.getColList("", "[COL_NAME]", ",\n\t", "", "((INS) and REW)")%>
<%if(odiRef.getOption("AUTOMATIC_RECSRC").equals("1")) {%>, RECSRC <%}%>
, LOAD_ID
)
<%for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++) {%>
<%=odiRef.getDataSet(i, "Operator")%>
select
<%=odiRef.getColList(i,"", "[COL_NAME]", ",\n\t", "", "((INS and !TRG) and REW and !UD1)")%>
<%=odiRef.getColList(i, ",", "[EXPRESSION] [COL_NAME]", ",\n\t", "", "((INS and (TRG or UD1)) and REW)")%>
<%if(odiRef.getOption("AUTOMATIC_RECSRC").equals("1")) {%>, '<%=odiRef.getInfo("TARG_NAME")%>' <%}%>
, <%=odiRef.getSession("SESS_NO")%>
from <%=odiRef.getOption( "SCHEMA_NAME" )%>.<%=odiRef.getSrcTablesList(i, "", "[TABLE_ALIAS]", ", ", "_X")%>
where (1=1)
<%=odiRef.getJoin(i)%>
<%=odiRef.getFilter(i)%>
<%=odiRef.getJrnFilter(i)%>
<%=odiRef.getGrpBy(i)%>
<%=odiRef.getHaving(i)%>
<%}%>