iam using ODI 22.214.171.124
Both source/target are in oracle 11g
1) Whats should be my LKM in source ?
the options available to me are
a) LKM ORACLE TO ORACLE ( dblink)
b) LKM ORACLE TO ORACLE ( datapump)
c) LKM SQL to ORACLE
d) LKM SQL to SQL
what is the adavntage of each of them and waht is the disadvantage of each of them?
and which is considarable to load suppose i have a 10milions of records in source.
pls share me your valuable knowlwdge.