Hi everyone,
We're looking at doing some broad clean-up of all of our bad address records - getting all the bad zip codes to be the same, with the same city and state, among other things. Anyone else done this and have any pieces of advice, technically speaking or otherwise? I'm nervous to operate on this many records in our live environment but would prefer specific fear to general!
Thanks!
Frannie
A familiar topic; address cleanup is at the heart of our regular data hygiene processes, both via SA job and manual checking.
> I'm nervous to operate on this many records in our live environment
I'd recommend making your matching code very strict, and your updates exceedingly precise, to begin with, so that it affects as few records as possible and you can easily review them all before and after. As your confidence grows, so may your updates...