Category Archives: Uncategorized

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 »

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 »

State Transition Testing

State transition testing primarily focuses on all the states of the software under test all the transitions to and from the states What is meant by the states and transitions in a software under test?              Determining states are often most difficult part of state transition testing. Suppose we are… Read More »

Decision table testing with example

In the previous blog post, we learned about two important test case design techniques such as Equivalence partitioning, and Boundary value analysis. These techniques are mainly used to test individual input conditions. However, decision table testing allows us to examine combinations of conditions. Decision table testing is a black box design technique in which test cases… Read More »