O'Reilly logo

Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide by Reza Rad

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

Time for action – using Data Quality Project for cleansing

In this example, we will use the Address KB Knowledge Base to clean the incoming data from an Excel file. There is a point to be noted here; the incoming data has one file for the address—the composite domain named Full Address. So we have to map the incoming address column to this Full Address domain. And then the Knowledge Base will perform the composite domain parsing. There are three types of composite domain parsing: reference data, in-order, and Knowledge Base parsing. In this example, we will use Knowledge Base parsing, which works based on delimiters and Knowledge Base domain values and rules.

We will export the result of the data cleansing to a file at the end. Perform the following ...

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