This content has been marked as final. Show 3 replies
first, there is now Informatica "source qualifier override" type functionality in OWB. The idea of owb is that you build every piece of the mapping using owb operators.
You have to create a oracle db module (data source) with a connection to your remote database.
Then create another (warehouse target) db module where you want to store the data.
Then use the table and function from the data source module and your target table from the target module.
Deploy the mapping to the target module. The required db links will be created automatically.
Hi David, that was my original idea also. Actually, we could just as easily create the view in the target database (they don't want new views added to the production ERP system). For some reason, the client seems uncomfortable with this, not sure why (it'll sure be more cost-efficient to do it that way).