Facts and Dimensions

February 17, 2017
Fact tables

Add columns to a fact table in the Data Warehouse

February 7, 2017
Fact Data

All you need to know about Facts and Types of Facts.

Lets start with the word called ‘granularity’ or ‘the grain’ first and then we understand the Fact. Later we will proceed with the types of Facts. […]
February 1, 2017
Data Load Strategy

What is data load strategy for testing? How to perform it? and How to test full load and incremental load?

What is the Data Load Strategy? Depending on the phase in which you take this up the answer will vary. For example, if you are looking […]
January 31, 2017
database Schema

Which table should be loaded first? Fact or Dimensions?

Let’s understand this with an example.. If you have sales fact table which is loaded first with a record with a sale of $5000. You are curious […]