Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Mapping - Creates a DB Link to connect to the source tables

Arnab PNov 12 2019 — edited Nov 12 2019

Hi,

I have created a few mappings in a project which takes data from a set of source tables and performs some simple transformations and loads the target tables. What I am a little confused about is the fact that when I generate the code in Simulation Mode and see the generated code it is showing that it is creating a DB link to access the source schema and then using this DB link to generate the Insert Query and finally dropping the DB link after it has run the insert query.

I am not sure why a DB link is getting created or which parameters in the mapping is incorrect that is making ODI to create a DB  link to access the source tables.

Can anyone please help me understand under what conditions or settings in the mapping/data model ODI needs to create a DB link to access the source tables and run the mapping?

Thanks

Arnab P

Comments

Post Details