This content has been marked as final. Show 2 replies
925197 wrote:Create 2 dataserver for db001. One for schema ABC ,another for schema XYZ
I am facing an issue creating DBLINK.
Let me explain the scenario.
I have 2 databases on 2 different machines
Source Machine1 :
schemas: ABC ,XYZ
Tables : A from ABC,X from XYZ
Target Machine 2:
For loading data into P table(interface) require A from ABC,X from xyz.
I require 2 dblinks are PQR-ABC,PQR-XYZ.
my problem is when i am creating dlinks using ODI it is creating only 1 dblink with name db001.
How to overcome this situation
Specify the dblink name in dataserver.
I need 2 dblinks
I have created 2 data servers 1 for ABC,1 for XY but we have one instance name that is db001 to 2 dataservers