Oracle Warehouse Builder deployment problem

[xuewei]

Hi,

I am trying to run a simple mapping to transfer data from one Oracle DB into another Oracle DB(Warehouse). There are not errors when I validate the mapping. But, I always get an error "PL/SQL: ORA - 00942: table or view does not exit" when I attempt to deploy my PLS scrip that executes the mapping. I also notice that there are not script for database link in the same project. Does this cause the problem? Any help in resolving this would be greately appreciated.

Thanks

Xuewei

 

[Subhashab]

The problem is not setting the database link. In the Mapping Properties, u will fid the target and source options. On expanding the source option u will find the database link. choose the DB link with with u created the source.
Once done , validate and generate to see the DB link used in the script.