SQL Power Business Intelligence Productivity Tools
Company OverviewBusiness Intelligence Productivity ToolsQuick-Start Implementation ServicesDemos & TurotialsFrequently Asked Questions (FAQ)Open Source Community ResourcesSQL Power ForumImplementation & Technology PartnersGet SQL Power SoftwareContact Us

SQL Power Software Forum
SQL Power Software Forum
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page  [Register] Register /  [Login] Login 
Creating a Data Cleansing Map/Dictionary  XML
Forum Index » SQL Power DQguru Discussion
Author Message
[Post New]2010-01-08 15:07:08
    Subject: Creating a Data Cleansing Map/Dictionary
[Up]
maxdemarzi


Joined: 2010-01-08 14:56:03
Messages: 1
Offline
I just found out about your product and I wonder if it would fit our needs.

I'll use an example. Let's say you have 200k job titles. A lot of them match up just fine, but you have misspellings, variations, someone adding the word "lead" or Senior/Sr./Snr etc.

You want to produce a "clean" set of job titles, how would you go about doing this with this tool, and would it be able to give you a MAP of what was changed and to what it was changed to.

So you'd have some way to get that:
Sneior Developer -> Senior Developer
Sr. Developer -> Senior Developer
Sr Developer -> Senior Developer

and so on... so you can go fix a legacy system (by text file search and replace).

Thanks,
Max
[Post New]2010-01-08 17:49:58
    Subject: Re:Creating a Data Cleansing Map/Dictionary
[Up]
Jeff
SQL Power Developer
[Avatar]

Joined: 2007-06-27 18:31:33
Messages: 410
Offline
Hi Max,

There is a feature called 'Translatation Words & Groups' in the DQguru that should do what you're describing.
-Jeff
[Post New]2010-08-13 10:50:10
    Subject: Re:Creating a Data Cleansing Map/Dictionary
[Up]
Cristian Orellana Castillo


Joined: 2010-08-03 11:14:44
Messages: 1
Offline
Jeff wrote:Hi Max,

There is a feature called 'Translatation Words & Groups' in the DQguru that should do what you're describing.


Does this means I've to manually enter the translations? Is there a way to generate those automatically?
[Post New]2011-12-15 06:15:29
    Subject: Re:Creating a Data Cleansing Map/Dictionary
[Up]
brent31976


Joined: 2011-12-15 06:03:48
Messages: 3
Location: Texas
Offline
As I know there is no way to do that.Have you seen this new market report: "Global Gas Shales Development, 2011 - North America Sets The Momentum For Shale Gas Developments Worldwide"? I looks like it's got some new information on <company>.
http//www.fastmr.com/prod/281393_global_gas_shales_development_2011_north_america.aspx
It's not cheap, but it might be worth it.
[Post New]2012-02-02 06:03:58
    Subject: Re:Creating a Data Cleansing Map/Dictionary
[Up]
punna33


Joined: 2012-01-21 00:19:32
Messages: 3
Offline
[quote=brent31976]As I know there is no way to do that.Have you seen this new market report: "Global Gas Shales Development, 2011 - North America Sets The Momentum For Shale Gas Developments Worldwide"? I looks like it's got some new information on <company>.
http//www.fastmr.com/prod/281393_global_gas_shales_development_2011_north_america.aspx
It's not cheap, but it might be worth it.[/quote]


it not cheap
[Post New]2012-02-02 06:04:38
    Subject: Re:Creating a Data Cleansing Map/Dictionary
[Up]
punna33


Joined: 2012-01-21 00:19:32
Messages: 3
Offline
[quote=punna33][quote=brent31976]As I know there is no way to do that.Have you seen this new market report: "Global Gas Shales Development, 2011 - North America Sets The Momentum For Shale Gas Developments Worldwide"? I looks like it's got some new information on <company>.
http//www.fastmr.com/prod/281393_global_gas_shales_development_2011_north_america.aspx
It's not cheap, but it might be worth it.[/quote]

[Post New]2012-02-02 06:06:15
    Subject: Creating a Data Cleansing Map/Dictionary
[Up]
punna33


Joined: 2012-01-21 00:19:32
Messages: 3
Offline
looks like it's got some new information on <company>.
http//www.fastmr.com/prod/281393_global_gas_shales_development_2011_north_america.aspx
 
Forum Index » SQL Power DQguru Discussion
Go to:   
Powered by JForum 2.1.8 © JForum Team