CODEWITHSUNDEEP
oracle-databaseoracle11gdblinkoracle-data-integrator
user6029999
user6029999

Reputation: 31

How to get DBLink name in ODI KM

I'm using Oracle Data Integration and i need to integrate in an IKM a source DBLink.

I have a simple mapping between one source table and one target table. The source table is on another database so I need to use a DBLink. I have created the DBLink in the topology and associated to the source Data Server.

I tried to "catch" the DBLink name using <%=odiRef.getInfo("SRC_DSERV_NAME")%> but i get the target instance instead of source DBLink(instance).

Any suggestions?

Upvotes: 0

Views: 2418

Answers (1)

user6029999
user6029999

Reputation: 31

In the meantime I've found the solution: <@=odiRef.getObjectName("R","<%=odiRef.getSrcTablesList("", "[TABLE_NAME]", "", "")%>","D")@>.

Upvotes: 2

Related Questions