Skip to Main Content

Database 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!

Simple ETL

672625Jan 26 2009 — edited Jan 29 2009
Hi, I’m learning to use OWH. I tried to make a simple etl, only copy from a table to other, these are in different schemas.
But, fail the debug, the deploy and when I ran directly the code in sql plus the package was compile with errors.
I follow the next steps:
1.-Create the new Project “ETL1”
2.-Add a new Oracle DB, warehouse destination “metadata2”
3.-Add a new Oracle DB, source DB “Source1”, location with user “system” to schema “bise1_saleswh”, I tried with user bise1_saleswh and owbrepos_owner too
4.-Importa table “sales”
5.-Add a new Oracle DB, source DB “Destination1”, location with user “union” to schema “union”, I tried with user bise1_saleswh and owbrepos_owner too
6.-Import the table “Table1”, it’s have three column Value1, Value2 and Value3, all Number 10,2
**Validation OK**
7.-Create a new map in “metadata2”.
8.-Drag the tables “sales” and “table1”
9.-Join column “Amount” to “Value1”, “Quantity” to “Value2” and “Cost” to “Value3”
**Validation OK**
10.-Start debug, the location is OK (data in source and destination). Continue with the operation and OWH send the error dbg1012.
11.-Then, generated the code and copied in sql plus (“union” schema), it’s finish with compile errors.
12.- I find in the console manager the package and have error PLS-00201
13.-The package body has the errors PLS-00905 and PLS-00304

Please, tell how create this etl, I need create more complex etl later.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 26 2009
Added on Jan 26 2009
2 comments
996 views