why we are using Db Link LKM, to fetch data from remote server
we can achieve same thing through creating DATA SERVER in ODI and creating Physical topology and logical topology
and from that we can create model ??
than what are the benefits to us DB LINK LKM
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.