Jerry%20Held

1
(No Transcript)
2
Oracle Warehouse Builder 10gEnsure Data Quality
Session id 40153

• Ali El Kortobi, Senior Development DirectorMark
  Van de Wiel, Principal Product Manager
• Oracle Corporation

3
Next Steps.

• Recommended sessions
• 40152 Oracle's Complete, Integrated BI
  Technologies
• 36715 Life Cycle Management using OWB9i
• Recommended demos and/or hands-on labs
• 40344 Oracle Business Intelligence and Data
  Warehousing Hands On Lab
• See Your Business in Our Software
• Visit the DEMOgrounds for a customized
  architectural review, see a customized demo with
  Solutions Factory, or receive a personalized
  proposal. Visit the DEMOgrounds for more
  information.
• Relevant web sites to visit for more information
• http//otn.oracle.com/products/warehouse/content.h
  tml

4
Reminder please complete the OracleWorld
online session surveyThank you.
5
Agenda

• Data Integration
• Oracle Warehouse Builder 10g
• Data Quality
• Demonstration
• Summary
• QA

6
What is the need for Data Integration?

• Provide access to business data
• Analysis
• Summaries
• Ad hoc query
• Forecasts
• Predictions
• Define the architecture

7
How do you spend System build time (Gartner)?

• Provide access to business data
• Analysis
• Summaries
• Ad hoc query
• Forecasts
• Predictions
• Define the architecture

20
80
8
What does Data Integration architecture consist
of?

• 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
What does Oracle Warehouse Builder 10g (OWB10g)
add?

• Mission to solve all data integration needs by
  protecting and leveraging investments in the
  Oracle database and other Oracle products

10
What Data Integration areas are covered by OWB10g?

• 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

11
What is the benefit of leveraging the Oracle
database?

• OWB10g leverages Oracle database
• Performance
• Scalability
• Security
• Availability
• OLAP
• ETL
• Data Mining

12
Then, are you experiencing any problem?
Users see invalid results!
13
Why do you run into Data Quality Issues?

• Different systems
• End-user input
• Different interpretations
• Case sensitivity
• Typos
• No standardization
• Source system bugs
• Etc.

14
D E M O N S T R A T I O N
Can you show how OWB10g can help?
15
Why would you use OWB10g for Data Integration?

• One integrated design environment

Design
Import
Extract
Load
16
Summary Version Management

• Capture design definitions
• High level cascade
• Individual definitions
• Including dependees
• Perform comparisons
• Restore definitions
• Manage environments

Manage system change
17
Summary Mapping Debugger

• Graphical debugging environment
• Debugging features
• Data definition
• Data viewing
• Breakpoints
• Watch points
• Error messages
• Easy to use

Quick and accurate data flow debugging
18
Summary Data Quality in ETL

• Name and Address
• Parsing
• Validation against external libraries
• Standardization
• Augmenting
• Certified postal reports

Achieve more accurate Name and Address data
19
Summary Data Quality in ETL

• Match and Merge
• Applies to any set of data (not just NA data)
• Merged results
• Cross-reference results
• Infinite set of match rules
• Infinite set of merge rules
• Names and addresses enables 'house-holding'
• 'Fuzzy' matching and merging

Achieve correct results
20
Summary

• Oracle Warehouse Builder 10g solves all data
  integration needs by protecting and leveraging
  investments in the Oracle database and other
  Oracle products

21
A
22
(No Transcript)