Using Data Quality Services
Now let us jump straight into using DQS. We will begin by creating a basic table in SQL Server, which has some valid and invalid data that needs cleansing. Here is the table we are going to use for this example, followed by the code that created it:
The following code creates the table shown in the previous screenshot:
CREATE DATABASE TEST GO CREATE TABLE Customer ( CustomerName varchar(200), DateOfBirth datetime, Sex char(10), Salary int, LoanAmount int )
GO INSERT INTO Customer VALUES ('John Smith', '01/February/1980', 'M', 50000, 100000), ('Alice Jones', '14/April/1990', 'Female', 75000, 1000), ('Simon Evans', '01/January/1900', ...Get What's New in SQL Server 2012 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.
