Address Cleansing in DataStage ???

badhri · Post by **badhri** » Thu Oct 24, 2002 7:03 am

Greetings,

Does DataStage supports Address Cleansing/Parsing Functionalities. I am looking for functioanlities like Address De-duplication as available in the Data Cleansing.

I find that that new ETL tools also have the Data Cleansing coupled to them.

Thanks in Advance.

Badhri ...

chulett · Post by **chulett** » Thu Oct 24, 2002 9:55 am

Unless you write them yourself, you'll need to invest in another part of Ascential's Suite - in this case INTEGRITY XE which is their 'Data Quality & Cleansing' component.

-craig

ray.wurlod · Post by **ray.wurlod** » Fri Oct 25, 2002 5:55 pm

Excellent advice! Everyone I know who's tried to write it themselves has ended up acquiring other specialist software. It's a really ugly task!

chulett · Post by **chulett** » Sat Oct 26, 2002 8:23 am

Well, not to toot my own horn or anything, but I *have* written an address parsing and normalization routine which is working pretty darn well for us, all things considered. <g> However, for large data sets and other quirky address things like the 'de-duplication' features that badhri mentions, you really need to look at something like INTEGRITY. I've seen the dog-and-pony show and its feature set was quite impressive.

-craig

ray.wurlod · Post by **ray.wurlod** » Sat Oct 26, 2002 3:51 pm

Does yours do non-US addresses?

Congratulations on reaching 50 posts, BTW.

chulett · Post by **chulett** » Sat Oct 26, 2002 5:57 pm

Oh, goodness no. And thanks!

=;^)