ETL Testing and Data Quality Governance Software – The Missing Link Data has become critical to the business. Hence, enterprises are investing time, money and resources in data-centric systems such as data warehouse, MDM, CRM & migration projects. However, all research done by independent agencies indicates that There is such a high failure/delays in implementations…
ETL Testing Vs. Application Testing – The Fundamental Difference 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…
How to test an ETL Process – Basic Concept 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…
iCEDQ Platform vs Data Quality Tools When people hear about iCEDQ, the first reaction is… “Hey, I already have a data quality tool! Why do I need iCEDQ?” In this article let’s contrast iCEDQ with any other data quality tools available in the market. What is iCEDQ? iCEDQ is a Quality Assurance and Test Automation…
ETL Development & ETL Testing – a Pipeline for Data Warehouse Testing ETL is a process of extracting (E), transforming (T) and loading (L) the data into the data warehouse or any other data-centric system. The process involved in developing these ETL processes is time consuming and usually follows the steps below: 1. Understand the…
ETL Testing – Unit Testing vs. Quality Assurance for Data Warehouse 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…
3 Reasons Why You Need to Perform ETL Testing 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,…
The Data Migration Process & the Potential Risks What is Data Migration? Data migration is the process of transferring data from one system to another system, known as the target system, using a variety of tools and techniques. Below are the different types of migrations which are encountered in different enterprises: Database Migration: This involves…
Data Migration Testing Techniques to Migrate Data Successfully We discussed the potential risks involved with the data migration process in our last iCEDQ insight. As previously mentioned, data migration is an important process where data from one system is transferred to a new, target system. The threat of data loss, data corruption, extended downtime, and…
Agile Data Warehouse Testing & Data Migration Testing Automate data warehouse etl testing and migration testing the agile way from Sandesh Gawande Development of a data warehouse, ETL, data migration or conversion always faces an ever-decreasing timeline. These implementations can take years to complete and users are not ready to wait that long. The…
