Page 1 of 1
Address Cleansing in DataStage ???
Posted: Thu Oct 24, 2002 7:03 am
by badhri
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 ...
Posted: Thu Oct 24, 2002 9:55 am
by chulett
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
Posted: Fri Oct 25, 2002 5:55 pm
by ray.wurlod
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!
Posted: Sat Oct 26, 2002 8:23 am
by chulett
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
Posted: Sat Oct 26, 2002 3:51 pm
by ray.wurlod
Does yours do non-US addresses?
Congratulations on reaching 50 posts, BTW.
Posted: Sat Oct 26, 2002 5:57 pm
by chulett
Oh, goodness no. And thanks!
=;^)