Is there an application out there that will allow us to cleanse/merge-purge
the name fields for a consumer as well as for a commercial data warehouse?
In other words, we want to take, for example, Walmart, Wal-Mart, Walmart
Corp, etc and boil it down to a single WalMart Corporation entity.
An example of the consumer side would be Jim Smith, James E. Smith, Jimmy
Smith, etc.
Thanks!Welcome to the world of data scrubbing. There is no corporate lookup
function, you will have to do some string manipulation and parsing to clean
the data. If you can convince the users/business units to do this, the
better.
Ray Higdon MCSE, MCDBA, CCNA
--
"Paul Stanial" <p_stanial@.webfirst.com> wrote in message
news:102lb9shn77u392@.corp.supernews.com...
> Is there an application out there that will allow us to
cleanse/merge-purge
> the name fields for a consumer as well as for a commercial data warehouse?
> In other words, we want to take, for example, Walmart, Wal-Mart, Walmart
> Corp, etc and boil it down to a single WalMart Corporation entity.
> An example of the consumer side would be Jim Smith, James E. Smith, Jimmy
> Smith, etc.
>
> Thanks!
>
>|||Thanks for the response. I guess I'm thinking that if we could go against a
table with all registered U.S. corporations (e.g. D&B?), then we could
relate the names in the records, along with their addresses and City to the
correct corporate entity and then aggregate the relevent fields from each
into the new "master record."
Thanks again...
"Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
news:OpSpUiR8DHA.360@.TK2MSFTNGP12.phx.gbl...
> Welcome to the world of data scrubbing. There is no corporate lookup
> function, you will have to do some string manipulation and parsing to
clean
> the data. If you can convince the users/business units to do this, the
> better.
> --
> Ray Higdon MCSE, MCDBA, CCNA
> --
> "Paul Stanial" <p_stanial@.webfirst.com> wrote in message
> news:102lb9shn77u392@.corp.supernews.com...
> cleanse/merge-purge
warehouse?
Jimmy
>|||I don't think it exists or at least published anywhere, I could be wrong.
Ray Higdon MCSE, MCDBA, CCNA
--
"Paul Stanial" <p_stanial@.webfirst.com> wrote in message
news:102nk04oc8h1q91@.corp.supernews.com...
> Thanks for the response. I guess I'm thinking that if we could go against
a
> table with all registered U.S. corporations (e.g. D&B?), then we could
> relate the names in the records, along with their addresses and City to
the
> correct corporate entity and then aggregate the relevent fields from each
> into the new "master record."
> Thanks again...
> "Ray Higdon" <sqlhigdon@.nospam.yahoo.com> wrote in message
> news:OpSpUiR8DHA.360@.TK2MSFTNGP12.phx.gbl...
> clean
> warehouse?
Walmart
> Jimmy
>
Friday, March 9, 2012
Help-Name Standardization Problem
Labels:
application,
cleanse,
commercial,
consumer,
database,
fields,
help-name,
merge-purgethe,
microsoft,
mysql,
oracle,
server,
sql,
standardization
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment