"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!
>
>
>

"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...
> > 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!
> >
> >
> >
>
>

"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...
> > 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!
> > >
> > >
> > >
> >
> >
>
>