- The data prepared in the previous section is clean. For the DQS cleansing project, use the following code to add two rows with incorrect data:
USE DQS_STAGING_DATA; SELECT CustomerKey, FullName, StreetAddress, City, StateProvince, CountryRegion, EmailAddress, BirthDate, Occupation INTO dbo.CustomersCh05DQS FROM dbo.CustomersCh05 UNION SELECT -11000, N'Jon Yang', N'3761 N. 14th St', N'Munich', -- incorrect city N'Kingsland', -- incorrect state N'Austria', -- incorrect country N'jon24#adventure-works.com', -- incorrect email '18900224', -- incorrect birth date 'Profesional' -- incorrect occupation UNION SELECT -11100, N'Jacquelyn Suarez', N'7800 Corrinne Ct.', -- incorrect term N'Muenchen', -- another incorrect city N'Queensland', ...
