In this recipe, you will create a view with some dirty data and use a DQS cleansing project to cleanse it. You will use the DQS knowledge base prepared in the previous exercise.
This recipe assumes that you have built the DQS knowledge base from the previous recipe. In addition, you need to prepare some demo data in advance. In SSMS, use the following query to prepare the data:
USE DQS_STAGING_DATA; SELECT C.CustomerKey, C.FirstName + ' ' + c.LastName AS FullName, C.AddressLine1 AS StreetAddress, G.City, G.StateProvinceName AS StateProvince, G.EnglishCountryRegionName AS CountryRegion, C.EmailAddress, C.BirthDate, C.EnglishOccupation AS Occupation INTO dbo.CustomersCh05 FROM AdventureWorksDW2014.dbo.DimCustomer AS C INNER JOIN AdventureWorksDW2014.dbo.DimGeography AS G ON C.GeographyKey = G.GeographyKey WHERE C.CustomerKey % 10 = 0; GO