This content has been marked as final. Show 3 replies
It depends on you which one you will choose based on the performance.1 person found this helpful
I will give a try if i have millions of record to findout if the loading is faster or not.
DB link is the fastest way to retrieve data from another Oracle Database.1 person found this helpful
But if you've only a small amount of rows, you can try other LKMs.
If you don't use DB Link, you will copy the source data in your target working schema.
A real C$ table will be created and it will be used to create your I$ table (staging integration table)
If you use DB Link, you won't copy the source data. You will just creat a view of these data and reads the view to generate your I$ table.