This discussion is archived
3 Replies Latest reply: Sep 30, 2013 4:57 AM by RAM_STUDENT RSS

KM'S

ng461 Newbie
Currently Being Moderated

Hi all,

iam using ODI 11.1.1.7

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.


Thanks,

ng461

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points