Hi,
I have the following Data Servers
Source: Oracle DB
Target: Oracle DB (This has the DB Link going to the Source)
I have been trying out the following LKMs but not being successful:
LKM Oracle to Oracle (DBLink)
LKM Oracle to Oracle Pull (DBLink)
LKM Oracle to Oracle Push (DBLink)
Which one should I use and which Data Server should I add the DB Link to?
BTW, it works when I use LKM SQL to Oracle but takes very long to load the data into the Target table.
ODI Version: 12.2.1.2.6