Data Correction with Data Quality Services

doi:https://doi.org/10.1007/978-1-4842-0082-7_5

Data Correction with Data Quality Services

Andy Leonard,Tim Mitchell,Matt Masson,Jessica M. Moss,Michelle Ufford-2014-01-01-Apress eBooks

2

TL;DRAbstract

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.

Chat with Paper

AI Agents for this Paper

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

Data deduplicationComputer scienceDatabaseData qualityKey (lock)Data miningSQLData warehouse

Chat

Click to start Chat