1 / 10

November 10 th , 2011

November 10 th , 2011. Cleansing Data in SSIS. David Faibish, Senior Program Manager SQL Server Data Quality Services. Microsoft SQL Server 2012. Agenda. The Business Case. DQS Component Overview. Configuring the DQS Component. Demo. Tips and Best Practices . The Business Case.

mairead
Download Presentation

November 10 th , 2011

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. November 10th, 2011 Cleansing Data in SSIS David Faibish, Senior Program Manager SQL Server Data Quality Services Microsoft SQL Server 2012

  2. Agenda The Business Case DQS Component Overview Configuring the DQS Component Demo Tips and Best Practices

  3. The Business Case • Data Quality is required as part of an on-going batch processing • The DQS SSIS component leverages DQS knowledge into batch processing

  4. DQS Component Overview Reference Data Services Activity Monitoring Interactive Cleansing Project DQS Server Review & Manage Monitor SSIS Package New Source + Mapping DQS Cleansing Component Knowledge Base Destination Suggestions Values/Rules Correct & Corrected Reference Data Definition Invalid

  5. Configuring the DQS Component Configure the DQS server and KB 1 2 3 1 Map required columns to domains 2 • Perform output Advanced settings, including cleansing info columns 3

  6. DQS Cleansing SSIS Component Demo

  7. Tips and Best Practices Use KBs you trust! 1 Use Conditional Split for improved control and automation 2 Use DQS Client for reviewing SSIS results 3 Use SSIS Cleansing Info outputs for further processing: analytics, integration, etc. 4

  8. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  9. Additional DQS Resources DQS Forum Come participate in DQS related discussions in our DQS forum on MSDN DQS Blog Tips, tricks and guidance on best practices for using DQS – courtesy of the DQS team DQS Movies A set of getting started movies for an easy introduction to DQS Available Here Available Here blogs.msdn.com/b/dqs

  10. © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related