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!

odiRef.getTable("L","TARG_NAME","A") returns "DEFAULT" in ODI 12

Pavel GoncharenkoMay 14 2014 — edited May 14 2014

Hello, could you like to help me?

I used ODI 11 before, I have upgraded my repository to version 12. I have a problem. Every auxiliary table (in LKM, IKM) has name like I$_0DEFAULT, C$_DEFAULT, instead of I$_0TABLE_NAME and C$_0TABLE_NAME.

I have this expression in my LKM module:

<%=snpRef.getTable("L", "COLL_NAME", "W")%>

And I get this substitution:

MY_SCHEMA.C$_0DEFAULT

I have this expression in my LKM module:

odiRef.getTable("L","TARG_NAME","A")

And I get this substituition:

MY_SCHEMA.DEFAULT

What should I do to fix this problem? How can I get the table name in ODI 12?

Thank you in advance.

This post has been answered by mRainey on May 14 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2014

Added on May 14 2014

#business-intelligence-applications, #data, #data-integrator, #oracle, #system-management-and-integration

1 comment

1,149 views