November 10
Download
1 / 10

Cleansing Data in SSIS - PowerPoint PPT Presentation


  • 73 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Cleansing Data in SSIS' - mairead


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Slide1 l.jpg

November 10th, 2011

Cleansing Data in SSIS

David Faibish, Senior Program Manager

SQL Server Data Quality Services

Microsoft

SQL Server 2012


Agenda l.jpg
Agenda

The Business Case

DQS Component Overview

Configuring the DQS Component

Demo

Tips and Best Practices


Slide3 l.jpg

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


Slide4 l.jpg

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


Slide5 l.jpg

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


Dqs cleansing ssis component l.jpg

DQS Cleansing SSIS Component

Demo


Slide7 l.jpg

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


Resources l.jpg
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


Slide9 l.jpg

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


Slide10 l.jpg

© 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.


ad