Data cleansing with Data Quality Projects
Knowledge Bases are created for one main reason—cleaning data. Data Quality Projects (DQPs) are created for the same reason. Each DQP works with one Knowledge Base. It gets data from a source file or SQL Server database and applies the Knowledge Base on it. Then, the result of DQP can be exported to the database tables or files.
In this section, you will see how to create data quality projects to cleanse data. There is also another type of DQP for data matching, which will be discussed later in this chapter.
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.
