3 Replies Latest reply on Sep 30, 2013 11:57 AM by RAM_STUDENT



      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.