Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Clean Data Expand / Collapse
Author
Message
Posted Monday, August 19, 2013 11:07 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:07 AM
Points: 2,149, Visits: 2,151
Comments posted to this topic are about the item Clean Data
Post #1486103
Posted Monday, August 19, 2013 11:12 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:47 AM
Points: 3,093, Visits: 983
Great question!

I've never used DQS, but the correct answer just seemed the most logical.



Just because you're right doesn't mean everybody else is wrong.
Post #1486105
Posted Tuesday, August 20, 2013 1:32 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, November 20, 2014 4:29 AM
Points: 3,559, Visits: 2,671
Wow. It was just shot correctly in the dark. I am not aware of DQS. But curiousity made me look out for it, got some idea and hit the correct answer. Would love to learn a little more about it. Thanks for introducing totally new thing to me.
Post #1486132
Posted Tuesday, August 20, 2013 2:25 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:02 AM
Points: 2,200, Visits: 1,764
I use DQS quite a lot and those steps don't bear much relation to what you do.
1) Create/Map Knowledge Base
2) Create DQ Project
3) Run project to cleanse data
is more like it.
There is a "Configuration" option but it's not always necessary.
Post #1486139
Posted Tuesday, August 20, 2013 4:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 13,539, Visits: 11,342
Nice question about a pretty unknown product. Thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1486183
Posted Tuesday, August 20, 2013 5:56 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 2:00 PM
Points: 4,477, Visits: 3,929
I've never used it, but it looks like it might be something we could use. Thanks for the introduction to a product I know nothing about.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1486201
Posted Tuesday, August 20, 2013 7:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 11:05 PM
Points: 204, Visits: 86
QOTD is really a good platform to learn many new things we never even knew existed in SQL Server. One good one (DQS) I learned today again. Thanks a lot for this service.
Post #1486238
Posted Tuesday, August 20, 2013 7:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, November 21, 2014 1:23 PM
Points: 1,951, Visits: 1,473
Thanks for the question. I definitely learned something today.



Everything is awesome!
Post #1486244
Posted Tuesday, August 20, 2013 8:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
For more info on using DQS, MDS (Master Data Services), and SSIS together check out the White Paper/Tutorial:

Enterprise Information Management (EIM) using SSIS, MDS, and DQS together:
http://www.microsoft.com/en-us/download/details.aspx?id=35462

Data Quality Services Performance Best Practices:
http://www.microsoft.com/en-us/download/details.aspx?id=29075

Cleanse and Match Data by using EIM:
http://msdn.microsoft.com/en-us/library/jj836269.aspx

These products all compliment each other.
Post #1486274
Posted Tuesday, August 20, 2013 9:34 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:03 AM
Points: 1,895, Visits: 2,194
sqlnaive (8/20/2013)
Wow. It was just shot correctly in the dark. I am not aware of DQS. But curiousity made me look out for it, got some idea and hit the correct answer. Would love to learn a little more about it. Thanks for introducing totally new thing to me.


+1 Never have used this, and the excuse to go learn about it was well work it. Thanks for the question.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1486324
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse