1 / 24

Jean-Pierre Dijcks Principal Product Manager Oracle Warehouse Builder Oracle Corporation

Jean-Pierre Dijcks Principal Product Manager Oracle Warehouse Builder Oracle Corporation. Oracle Warehouse Builder An Introduction. Agenda. Oracle Warehouse Builder: Introduction ETL and Schema Design Metadata Management Data Quality Management Demonstrations: Basic ETL Capabilities

amena-hunt
Download Presentation

Jean-Pierre Dijcks Principal Product Manager Oracle Warehouse Builder Oracle Corporation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Jean-Pierre DijcksPrincipal Product Manager Oracle Warehouse Builder Oracle Corporation

  2. Oracle Warehouse Builder An Introduction

  3. Agenda • Oracle Warehouse Builder: • Introduction • ETL and Schema Design • Metadata Management • Data Quality Management • Demonstrations: • Basic ETL Capabilities • Migrating Data and Metadata • Managing Changes • Summary • Q & A

  4. Introduction

  5. What is Data Integration? • Consolidate date in one place (…) • Commonly referred to as: • ETT • ETL • Etc… • The one thing that will take a lot of time in your project plan

  6. What is the need for Data Integration? • Provide access to business data • One source of the truth • Analysis • Summaries • Ad hoc query • Forecasts • Predictions

  7. What does the Integration architecture consist of? • Consolidate data • Across systems • Define the target structures • Understandable (consolidated) presentation • Optimized for query retrieval • Set up this environment • Manage this environment • Maintain this environment

  8. What Data Integration areas are covered by OWB? • Consolidate data • Across systems • Define the target structures • Understandable (consolidated) presentation • Optimized for query retrieval • Set up the environment • Manage the environment • Maintain the environment } }

  9. ETL design Validate design Deploy Extract and Transform Data How do I use OWB? Data structure design Generate code Capture sourcedefinitions Oracle 8i/9i/10g

  10. ETL and Schema Design

  11. What design capabilities are there? • Data structures: • Dimensional • Relational • ETL processes: • Data flows • Process flows • End user access

  12. Focus on ETL • Data Flows • The core of Extract, Transform and Load • Allows you to design individual extraction routines • Graphical Editor • Process Flows • Groups several data flows • Contains many built-in activities such as notification, fork, FTP etc…

  13. Metadata

  14. What Metadata Management features are supported? • Security • Version management • Multi language support • Java API access • Scripting access • Read-only access (web browser) • Extensibility

  15. Can I do difference Analysis?

  16. What Lifecycle Management features are there? • Re-import / reconcile source structures • Graphical impact analysis • Graphical lineage • Upgrade target objects

  17. Data Quality

  18. What Data Quality features are there? • Name & Address cleansing • Matching/Merging records • Straight forward lookups • Advanced matching (business rules) • Advanced merging (business rules) • Reporting on results

  19. Demonstrations

  20. Demonstrations • Comprehensive ETL Capabilities • Migrating Data and Metadata • Managing Changes (if time permits…)

  21. Summary • You can manage any data movement using Warehouse Builder • You can migrate your data from a mainframe into Oracle with Warehouse Builder • You can easily switch your data movement to other sources with Warehouse Builder • You can manage the metadata in your system using Warehouse Builder • You can manage changes to your system with Warehouse Builder

  22. Q & Q U E S T I O N S A N S W E R S A

More Related