O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting ready

In order to test the DQS matching, you need to prepare some data. The following section contains a lot of code; therefore, you might want to use the code provided in the book's companion content.

First, you need to prepare a table with clean data. In SSMS, execute the following code:

-- Preparing the clean data tableUSE DQS_STAGING_DATA;CREATE TABLE dbo.CustomersClean(CustomerKey INT NOT NULL PRIMARY KEY,\FullName NVARCHAR(200) NULL,StreetAddress NVARCHAR(200) NULL);GO-- Populating the clean data tableINSERT INTO dbo.CustomersClean(CustomerKey, FullName, StreetAddress)SELECT CustomerKey,FirstName + ' ' + LastName AS FullName,AddressLine1 AS StreetAddressFROM AdventureWorksDW2014.dbo.DimCustomerWHERE CustomerKey % 10 = 0;GO ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required