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 ...
Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide 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.
