3 Replies Latest reply: Sep 30, 2013 6:57 AM by RAM_STUDENT RSS



      Hi all,

      iam using ODI

      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.