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', 'M', 20000, 25000), ('X L', '20/June/1981', 'M', 30000, 50000), ('Jim Bob', '08/November/1966', 'Male', 10000000, 25000), ('Hilary Smith', '14/September/1991', null, 30000, 45000) SELECT * FROM Customer
Understanding the interface is the key to understanding the DQS workflow. Open up...