MS SQL Data Mining Question:

Download Job Interview Questions and Answers PDF

What is Data purging?

SQL Server Data Mining Interview Question
SQL Server Data Mining Interview Question

Answer:

Deleting data from data warehouse is known as data purging. While loading data into staging or in the target table fresh data loading may be needed every time. In this scenario, data purging is needed to stage or target table prior to loading fresh data. Usually junk data like rows with null values or spaces are cleaned up. Data purging is the process of cleaning this kind of junk values.

Download SQL Server Data Mining Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know the storage models of OLAP?Explain what are the different problems that “Data mining” can solve?