ETL TESTING IN DATAWAREHOUSING
K. Vishnu Vandana, Visramsetty Sujatha · 2013
It has been observed that Independent Verification and Validation is gaining huge market potential and many companies are now seeing this as prospective business gain. Customers have been offered different range of products in terms of service offerings, distributed in many areas based on technology, process and solutions. ETL or data warehouse is one of the offerings which are developing rapidly and successfully. During the development of the data warehouse (DW), too much data is transformed, integrated, structured, cleansed, and grouped in a single structure. These various types of changes could lead to data corruption or data manipulation. Therefore, DW testing is a very critical stage in the DW development process. A number of attempts were made to describe how the testing process should take place in the DW environment. In this paper, I will concentrate on ETL testing techniques, the four different engagements existed in ETL Afterwards, I will highlight the weakness points that exist in the available DW testing approaches.