Techniques for data quality enhancing during development of corporate data warehouse

Аuthors

Sirotinsky V. V.^*, Semenov D. V.^*

Moscow Aviation Institute (National Research University), 4, Volokolamskoe shosse, Moscow, А-80, GSP-3, 125993, Russia

*e-mail: iprokaf@mai.ru

Abstract

Data cleaning aspects are discussed in the article as applies to data entering into some data warehouse from various sources. Principles are described to extract, transform and load data into warehouse as well as optimization techniques to reveal and correct «polluted» data.

Keywords:

corporate data warehouse; data retrieval; transformation; loading; cost optimization