Do you have a raw source of G-NAF data sitting a DB tables, or another product like QAS where the data is encrypted & proprietary and you use the engine to access/match against the data?
If the former, you could use Country to split out the obviously foreign addresses first and either attempt to push the unknowns through the AU rulesets, or attempt to enrich the unknowns with State/Country from G-NAF or Aus Post locality file, using the locality and/or postcode. If you get a match and can enrich, then reclassify as AU and go.
You could also use AUPREP to try to split out the address data from the locality data (limited benefit from what I've seen in the past though it might be better now).
Once it's parsed, then create your match strategy and go.
If the latter, you call it however you want, with or without DataStage.
If you don't have either you could get the plugin for DataStage/QualityStage, which gives you a stage to put in your job and it takes care of the matching for you.
http://www-01.ibm.com/support/docview.w ... wg24032994
Best Practice in Matching Address to GNAF
Infosphere's Quality Product
-
- Participant
- Posts: 527
- Joined: Thu Apr 19, 2007 1:25 am
- Location: Melbourne
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration