Home » SQL & PL/SQL » SQL & PL/SQL » Role of ETL Tool - OWB
Role of ETL Tool - OWB [message #224535] Wed, 14 March 2007 10:55 Go to next message
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member


I am in the designing and implementation of a Datawarehouse Profitability Solution for our client. I am working in the datawarehouse environment for the first time.
I have read that for ETL it's good to use OWB or some other ETL tools. However ETL can also be written through PL/SQL coding, so why do we need OWB? what is the significance of using OWB in datawarehouse environment. What role does OWB play in datawarehouse environment? Please guide me...
Thanks a lot in advance....

Re: Role of ETL Tool - OWB [message #224608 is a reply to message #224535] Wed, 14 March 2007 14:06 Go to previous message
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
The OWB User Guide has a part named "Benefits of using OWB":

My own opinion: OWB does a lot of stuff for you, so you don't have to code it yourself. On the other hand, you have to learn a new tool (and the people maintaining and administering the DWH too). But since datawarehousing comes with a lot of special techniques and methods you have to learn anyway, why not learn a tool too while you're at it...
Previous Topic: Can i Use the INSERT INTO on pl/sql TABLE
Next Topic: ORA-00984: column not allowed here
Goto Forum:

Current Time: Fri Oct 28 07:13:21 CDT 2016

Total time taken to generate the page: 0.10725 seconds