Advertisement

Data Correction with Data Quality Services

  • Andy Leonard
  • Tim Mitchell
  • Matt Masson
  • Jessica Moss
  • Michelle Ufford
Chapter

Abstract

Data Quality Services (DQS) was first introduced in SQL Server 2012. It provides data correction and data deduplication functionality—key components for most Extract, Transform, and Load (ETL) processes. This chapter describes how DQS integrates with SSIS and provides patterns that enable you to achieve reliable, low-effort data cleansing within your ETL packages.

Keywords

Knowledge Base Data Flow Domain Management Correction Rule Composite Domain 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Andy Leonard 2014

Authors and Affiliations

  • Andy Leonard
    • 1
  • Tim Mitchell
    • 1
  • Matt Masson
    • 1
  • Jessica Moss
    • 1
  • Michelle Ufford
    • 1
  1. 1.VAUnites States

Personalised recommendations