Posted: Wed Aug 07, 2013 1:15 am
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
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