Have you used DQS in an actual production environment?

Question

Have you used DQS in an actual production environment?

Jeff Moden

SSC Guru

Points: 1004312
More actions
January 20, 2013 at 4:39 pm

#267128

I'm just curious mostly because I don't use SSIS for anything...
Have you used DQS in an actual production environment? If so, do you have an specific examples of how it simplified things or what kind of data you used it on?
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 1

I recently saw Brian Knight do a demo of DQS to cleanse name and address data and it looked useful and robust enough to try it out for real but I have not had the opportunity to implement it in a production environment.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Jeff Moden (1/20/2013)
I'm just curious mostly because I don't use SSIS for anything...
Have you used DQS in an actual production environment? If so, do you have an specific examples of how it simplified things or what kind of data you used it on?

DQS isn't necessarily an SSIS thing. You can automate DQS a bit with SSIS, but you'd still have to build your knowledge base, which you do in the DQS tool.

But to answer your question: no I haven't used it in production yet. I do know there were a few performance issues when used in SSIS, but most of them have been solved by CU updates (and SP1 as well I think).

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 3

Koen Verbeeck (1/21/2013)
I do know there were a few performance issues when used in SSIS, but most of them have been solved by CU updates (and SP1 as well I think).

Now that you say that I remember that Brian mentioned those issues. The SSIS component was single-threaded in its initial incarnation but the updates made them multi-threaded.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

tomgough SSC-Addicted Points: 432 More actions · Answer 4

I'd be interested in hearing peoples' experiences myself - particularly in terms of managing the knowledge base