Diff b/w Address Cleanse Transforms

system · December 3, 2009, 1:16pm

Hi,

What is the difference b/w
Global_Address_Cleanse - - USA_AddressCleanse
and
USA_Regulatory_AddressCleanse Transforms avilable under Data Quality tab.

sjain (BOB member since 2009-04-17)

system · December 3, 2009, 4:13pm

USA Address Cleanse is a Global Address Cleanse preconfigured to US typical needs, e.g. EMEA engine turned off, global engine turned off, US engine turned on. In other words, as seen from the transform: none.

US Regulatory Address Cleanse (URAC) is a very specific address cleanse required by the US postal office, it does things the “regulatory” way. No idea what that means in practice though.

Werner Daehn (BOB member since 2004-12-17)

system · December 3, 2009, 5:15pm

The US regulatory address cleanse uses different directories to standardize your address data, and you cannot (as far as I know) CASS certify a US record through a global address cleanse.

and this really doesnt make much sense to me, since you can SERP ceritify Canadian records through a global address cleanse.

we split our US records to a US regulatory cleanse, and run everything else through global. US records parse MUCH better through the regulatory cleanse

jlynn73 (BOB member since 2009-10-27)

system · December 3, 2009, 6:18pm

Under the Data Quality tab you will see 2 transforms:

Global Address Cleanse (GAC)
U.S. Regulatory Address Cleanse (URAC)

If you open those up further you will see what we call a “Transform Configuration”. A transform configuration is a preconfigured “instance” of that transform with a specific set of settings. When you use a transform configuration in a dataflow you are inheriting those settings. So you can always go back and change the transform configuration in the transforms tab and that change will be inherited into all the dataflows where you use it allowing you to change your data quality rules/standards in one place (unless you override the setting specifically in the dataflow).

In terms of differences the prior post is on the right track. If you are doing CASS Certfied mailing for postal discount you MUST use the US Regulatory Address Cleanse transform. This will generate the 3553 Report and also gives you the other USPS options: DPV, LACSLink, SuiteLink, RDI, ANKLink, and NCOALink. All of which you do NOT get in the Global Address Cleanse transform.

In terms of general parsing and standardization the same general parsing and validation engine that we use in the URAC transform is used in the GAC transform. However, the standardization is applied differently. There is a consistent standardizer in the GAC transform so you can standardize all country address elements the same way or control them separately whichever you like. But generally you should get the same validation results. Some of those results can vary based on how you map your input fields and such though.

The various country transform configurations for GAC are there just as templates. You can create your own configuration for whatever countries you are processing or use the Global template which is setup to cleanse all countries. You don’t need to use the individual configurations for each country in your dataflow which is a common mistake.

Thanks,
Ryan

champlir (BOB member since 2007-10-25)

system · December 4, 2009, 10:09am

Thanks for your reaponse.

Iam using Data Services XI 3.2 and not able to run a simple Job having GAC for USA_ADDRESSCleanse is there. getting error

Transform <USA_AddressCleanse>:        Invalid City directory..

It means that i have address data but invalid for City only…?
or i need to add address directories to the reference data folder?

So which transform should i use which doesnt req any directories.?

one more question, address directories are required for any sort of address cleansing tranformation…is it right?

sjain (BOB member since 2009-04-17)

system · December 4, 2009, 5:47pm

CASS cycle L and M use different directories.

R3.2 is cycle M and uses the city10 directory.

the USPS/SAP should give you a break down of which directory is supported by which cass cycle, and its expected life cycle.

DQ 11.7.2 is cycle L and uses city9. (and I believe R3.1 is cycle L)

jlynn73 (BOB member since 2009-10-27)

system · December 6, 2009, 7:18am

I have tried to downloaded the latest version of Directories but the same are not available on the SAP Site.

Could you suggest some link where i can download latest Address Directories for XI 3.2

sjain (BOB member since 2009-04-17)

system · December 8, 2009, 11:12am

Now. I have installed DSXI3.0 and old Directories with city09,zcf09…
Then used USA_ADDRESSCLeansedTrasfrom with USA engine ON…got the error


Transform <USA_AddressCleanse>: Global Address Transform: DIRECTORY OUT OF DATE.  The specified ZIP+4 directory has expired...

Then i changed the value for Disable Certification to yes in the same USA_AC transform

Got the same error…

Then i replaced the USA_AC transform with Global_Address_Cleanse transform with b]Disable Certification [/b] to yes and global address engine ON

it works fine.

Now my questionis … do we get any difference in the output data if we use country specific transform…

sjain (BOB member since 2009-04-17)

system · December 9, 2009, 8:12pm

The Global_Address_Cleanse transform (USA engine enabled) uses the same underlying libraries as the U.S. Regulatory Address Cleanse transform in order to parse the input data. The parsed components should be the same with the exception of a few differences.

Parsing of PMB information, Rural Route addresses, highway contract addresses, and military addresses are different. This data is still parsed and will be found in different fields when compared to the U.S. Regulatory Address Cleanse transform.

chtaylor (BOB member since 2009-12-09)