From the course: Implementing a Data Warehouse with SQL Server 2022

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Create a custom knowledge base

Create a custom knowledge base - SQL Server Tutorial

From the course: Implementing a Data Warehouse with SQL Server 2022

Start my 1-month free trial Buy for my team

Create a custom knowledge base

“

- [Instructor] In order to use data quality services to cleanse your data, you need to have some information about what is correct and valid. This information is stored in a knowledge base and individual table columns from your input data source will get mapped to domains in the knowledge base. Knowledge bases can be augmented and updated over time with new rules and additional acceptable values so that they can grow with your business. In the last movie, we saw how to use the default knowledge base that stored information about valid locations within the United States but the true potential of data quality services relies on you being able to create new knowledge bases based on your own business. For this example, I want to create a knowledge base that includes all of the supplier names used by Wide World Importers. This will be useful to help ensure that data is entered consistently when it's copied out of a variety of…

Contents