![]() Click on Start and it will make the cleaning process and shows various results. Now the most important phase of the complete project. User can select one or multiple column mapping over here. In our case we will be using both of the mappings here. In the Colors knowledge base we had two columns – 1) Colors and 2) Shade. We will be using our Colors knowledge base which we have recently created. In the next screen it will ask which knowledge base to use. In reality you can easily use SQL Server table for the same.Ĭlick on New Data Quality Project to see start DQS Project. I am using another excel sheet here for simplicity purpose. We will try to take any random data and attempt to do DQS implementation over it. In the next screen you can actually add more rows as well see the frequency of the data as the values are listed unique.Ĭlicking next will publish the knowledge base which is just created. In our case it shows that Colors column have unique data whereas Shade have non-unique data and unique data rows are only two. Pre-processed data will show various information related to the source data. Clicking on the START will start the processing of the source data provided. Here is the screen which will demonstrate how the screen will look after creating domains.Ĭlicking NEXT it will bring you to following screen where you can do the data discovery. Here you can create a unique domain or domain which is compositely build from Colors and Shade.Īs this is the first example, I will create unique domain – for Colors I will create domain Colors and for Shade I will create domain Shade. I have selected Colors and Shade both as a source column.Ĭreating a domain is very important. Enter the name of the new knowledge base.Ĭlicking NEXT will bring up following screen where it will allow to select the EXCE file and it will also let users select the source column. The point which I am trying to show is that in Column A there are unique data and in Column B there are duplicate records.Ĭlicking on New Knowledge Base will bring up the following screen. They are independent columns and not related to each other. In our project we will be using the Excel as a knowledge base. Here is the Excel which we will be using. Let us start the building the Knowledge Base. Here are the two very important steps we will be learning in this tutorial. In this article we will see how we can learn about building Knowledge Base and using it to help us identify the quality of the data as well help correct the bad quality of the data. #Service client base telephone install#In the first article we learned to install DQS. This article is introduction to Data Quality Services for beginners. Connecting Error to Data Quality Services (DQS) on SQL Server 2012.Installing Data Quality Services (DQS) on SQL Server 2012.Here are two very important blog posts which one should go over before continuing this blog post about Data Quality Services. I have recently started to explore the same and I am really learning some good concepts. Data Quality Services is a very important concept of SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |