CHAPTER 5
Data Correction with Data Quality Services
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.
Note The Data Quality Services product requires some manual steps post-installation to create the DQS databases and set default ...
Get SQL Server Integration Services Design Patterns, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
