Transcript Summary - Oracle

Session id: 40153
Oracle Warehouse Builder 10g
Ensure Data Quality
Ali El Kortobi, Senior Development Director
Mark Van de Wiel, Principal Product Manager
Oracle Corporation
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.html
Reminder –
please complete the
OracleWorld online session
survey
Thank you.
Agenda






Data Integration
Oracle Warehouse Builder 10g
Data Quality
Demonstration
Summary
Q&A
What is the need for Data
Integration?
 Provide access to business data
–
–
–
–
–
Analysis
Summaries
Ad hoc query
Forecasts
Predictions
 Define the architecture
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%
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
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
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
What is the benefit of leveraging
the Oracle database?
 OWB10g leverages Oracle database:
–
–
–
–
–
–
–
Performance
Scalability
Security
Availability
OLAP
ETL
Data Mining
Then, are you experiencing
any problem?
Why do you run into Data
Quality Issues?
 Different systems
 End-user input
–
–
–
Different interpretations
Case sensitivity
Typos
 No standardization
 Source system bugs
 Etc.
D E M O N S T R A T I O N
Can you show how
OWB10g can help?
Why would you use OWB10g
for Data Integration?
 One integrated design environment
Design
Import
Mine
Cleanse
Extract
Transform
Load
Summary: Version Management
 Capture design definitions
–
–
–
High level cascade
Individual definitions
Including dependees
 Perform comparisons
 Restore definitions
 Manage environments
Summary: Mapping Debugger
 Graphical debugging environment
 Debugging features:
–
–
–
–
–
Data definition
Data viewing
Breakpoints
Watch points
Error messages
 Easy to use
Summary: Data Quality in ETL
 Name and Address
–
–
–
–
–
Parsing
Validation against external libraries
Standardization
Augmenting
Certified postal reports
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
Summary
 Oracle Warehouse Builder 10g solves all data
integration needs by protecting and leveraging
investments in the Oracle database and other
Oracle products
QUESTIONS
ANSWERS