What are the main benefits of using Oracle Warehouse Builder?
Among the main benefits of using Oracle Warehouse Builder are: · Due to a metadata driven approach OWB created solutions are 100% reproducable. All code is generated from a metadata repository and therefore reproducable at any point. · Changes are incorporated in a fast and efficient way because the central point for changes is the repository. From there the changes can be propagated in an intelligent way to systems already deployed. This is life-cycle support. · Focus on the market leading Oracle database ensures a tight fit and optimal tuning for this platform. · Source and target system reconciliation ensure that OWB always provides the correct representation of the systems in the organization. · OWB provides the users with data warehouse design, ETL design and life cycle management in one consolidated environment. · OWB provides users with a highly graphical user interface, which reduces hand coding to a minimum. Integration with other Oracle products For integration with Oracle Wo