Sql server - What is Data purging?

What is Data purging?

The process of cleaning junk data is termed as data purging. Purging data would mean getting rid of unnecessary NULL values of columns. This usually happens when the size of the database gets too large.

What is Data purging?

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.
Sql server - What are CUBES?
A data cube stores data in a summarized version which helps in a faster analysis of data. The data is stored in such a way that it allows reporting easily......
Sql server - What are OLAP and OLTP?
OLTP: Online Transaction and Processing helps and manages applications based on transactions involving high volume of data........
Sql server - What are the different problems that “Data mining” can solve?
Data mining can be used in a variety of fields/industries like marketing, advertising of goods, products, services, AI, government intelligence......
Post your comment