Query on Quality Stage Address Standardization

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
balu536
Premium Member
Premium Member
Posts: 103
Joined: Tue Dec 02, 2008 5:01 am

Query on Quality Stage Address Standardization

Post by balu536 »

Hello Everyone,
Is it possible to cleanse County column through CASS and GAV stages present in QualityStage.

Till date, we were cleansing Address, State, Zip, Country etc fields through these services. Just wanted to know whether COUNTY can also be cleansed or not? Please help on this.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Depends on what you mean by 'cleanse'. There is a COUNTRY rule set that will produce an ISO 2 and 3 country code based on the input country. This rule does not cover all countries, but it is an ok start.

If that is not what you are looking for, then can you provide some examples of input and desired output?
Regards,
Robert
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You'll need to check whether CASS includes COUNTY. (Being in Australia I don't use CASS all that much!).

Very few countries in the world divide their land by county, so I'd guess that GAV won't help here at all. But I'd be happy to be corrected on that.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

Wow - I need QualityStage. I inserted an 'R' in COUNTY....

Let me try again....

USAC (aka CASS) does not output County codes. Reference: http://pic.dhe.ibm.com/infocenter/iisin ... _file.html

AVI does output a 'SubAdminstrativeArea' that could be a county (depending on the country [see - I remembered the R there ;)]). Ref: http://pic.dhe.ibm.com/infocenter/iisin ... tcols.html
Regards,
Robert
Post Reply