Today all decisions in an organization are being made on the data available to them. Hence it has become critical to ensure that the does is free of any issues or defects. The way to ensure that there are no data issues and it is fit for the business, is to test, validate and compare…
An ETL process is at the heart of any data-centric system/ project be it Data Migration or Data Warehouse. All the data movement, transformation, and conversions are done by the ETL process in order to ensure that all the data is uniform in terms of quantity, quality, and format. So, why is ETL testing so…
Normally, the ETL developers as part of the development effort will do unit ETL testing of the ETL processes. These test include some spot tests and summary tests. A unit ETL test is a test written by the programmer to verify that a relatively small piece of ETL code is doing what it is intended…
The basic concept of ETL Testing and Data Warehouse Testing The answer lies in the understanding of an ETL process. An ETL process at its core reads data, applies a transformation on it and then loads the data. This can be represented by the following simplistic equation. Input Data + Transformation = Output Data The…
At the core, quality is the measurement of deviation between what is expected vs. actual. In quality assurance practice, we implement a set of tests to measure this deviation. The extent of the deviation indicates the quality of the software. In any application testing, there are three common terms that we will notice: Requirements Test…