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.