Simple ETL
672625Jan 26 2009 — edited Jan 29 2009Hi, 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