Extract, Transform and Load or ETL Process

Extract, Transform and Load or ETL refers to a process in Data warehousing in which data is extracted from multiple source systems, transformed into the proper format and finally loading to the target database. Let’s briefly look into each step of the ETL process.   Extraction Extraction is considered as the first part of the ETL… Read More »

Fact table types with examples

A fact table in a data warehouse contains business facts (or measures). These measures serve as the core of dimensional model and can be summed/ mathematically manipulated. The measures can be categorized as Additive Semi-additive Non additive Additive measures: These are the most flexible and useful facts Measures can be summed across any of the… Read More »

Data Warehouse Characteristics

Data Warehouse characteristics Data Warehouse is a subject oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision-making process.  Let’s look into these characteristics little deeper in order to get a better clarity. Subject oriented : Data warehouses designed to help people analyze the data. For example, if you wanted to learn about… Read More »

Introduction to ETL /Data warehouse Testing

Today let me introduce one of the much sought after skills in the testing industry. It’s ETL(Extract, Transform & Load) /Data warehouse testing. I will be writing a series of posts which will give you an overall idea about the overall ETLtest process. Before getting deep into the testing process, let’s understand the basic terminologies. What is a… Read More »

How defects are detected, documented, and categorized?

As testers, we deal with defects all the time. However how many of us understood the subtle difference between various terminologies like Bug/Failure/Fault/Defect & Errors? Even most experience testers often get confused with these terms. So today let’s examine each of these terms in detail: Errors : Errors are usually caused by human action. Or in other… Read More »

Exploring exploratory testing

Recently I have come across a question regarding exploratory testing in one of the software testing textbooks. Ralph was the project manager of a small telephone switching system development. He started out as an electrical engineer, specifically as a logic designer. As his career progressed,he acquired solid domain knowledge of telephone switching systems. When the project… Read More »

White box test design techniques (Part 3)

Loop Testing Loops considered as one of the important control structures in any programming language. As we have seen in the previous blog post, loops make path testing difficult by increasing the number of possible paths in programs. For example, If a program routine has one loop, each iteration through that loop reveals a new… Read More »