 |
Oracle Warehouse Builder |
| Name and address cleansing |
If your business intelligence systems include name and address related data in the target environment, you may have the following concerns: Do the persons registered to an address live there, do the companies exist, and does the address exist? Also, if you do know the address, but you do not know the zip code, could you find out? Use this session to learn how to answer these questions using name and address cleansing in Warehouse Builder.
| Level: |
Intermediate |
| Coverage: |
Versions 9.0.4*, 9.2, 10g |
| Publication: |
Online (and hands-on in the related materials) |
| Intended audience: |
Users who face the issue of inaccurate name and address data in their environment. |
|
Users who want to explore Warehouse Builder's name and address cleansing capabilities.. |
*Note: for the 9.0.4 Oracle used to provide Pure Name and Address options as part of the database server. This option is not available anymore for the 9.0.4 release. For 9.2 and 10g, Oracle works with partner solutions.
| Objectives |
 |
 |
Know the prerequisites to use Warehouse Builder Name and Address cleansing. |
|
Be able to design a mapping that performs Name and Address cleansing. |
| Pre-requisites |
|
|
Be familiar with Warehouse Builder's ETL basics. |
| Content |
|
| Until version 9.0.4 Oracle used to provide Name and Address cleansing libraries. For version 9.2 and onwards, Oracle works with partners who certify the integration with Warehouse Builder. The materials below are more specific to the 9.2 and 10g releases of Warehouse Builder, but users using version 9.0.4 with libraries provided by Oracle can use the same features. |
|
Component |
Version |
Estimated Duration (h)
|
Delivery
|
Availability |
|
Watch the Introduction to Name and Address cleansing viewlet |
(9.0.4) 9.2 / 10g |
0:15
|
 |
March 2004 |
|
Read the first section of the Data Quality Whitepaper, until Overview of the Match / Merge Process on page 11. |
(9.0.4) 9.2 / 10g |
0:45
|
|
March 2004 |
|
Review the Name and Address section of the Data Quality FAQ |
(9.0.4) 9.2 / 10g |
0:30
|
|
March 2004 |
|
Read the section Name and Address Operator in chapter 8 - Using Mapping Operators - of the Warehouse Builder User's Guide. |
(9.0.4) 9.2 / 10g |
0:40 |
|
March 2004 |
|
Enroll in the Oracle Warehouse Builder: Cleansing Data eClass and go through the relevant section about Name and Address cleansing* |
(9.0.4) 9.2 / 10g |
2:00
|
|
March 2004 |
* Note: to enroll in this class requires
access to the iLearning Online Library
may come at a cost.
Legend:  = recorded, = online, = paper,  = hands-on
|
Bookmark
