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

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

3. Oracle Warehouse Builder An Introduction

4. 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

5. Introduction

6. 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

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

8. 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

9. 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 } }

10. 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

11. ETL and Schema Design

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

13. 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…

14. Metadata

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

16. Can I do difference Analysis?

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

18. Data Quality

19. 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

20. Demonstrations

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

22. 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

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