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