When I create a Source Module in OWB, I define a DB link that is created in the OWB repository. That works fine. However, in order to run the data load from source to staging (staging is in a separate database than the OWB repository), another "target" database link must be used. I see no facility in OWB to generate and deploy a DB link in a target DB outside of the OWB repository.
I manually created a DB link in the target DB and the data load worked fine. But how do I get OWB to do this?
TIA,
David Wagoner
I manually created a DB link in the target DB and the data load worked fine. But how do I get OWB to do this?
TIA,
David Wagoner