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 […]
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. […]
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 […]
December 24, 2016

Junk Dimension – How would you design your DW tables if you had the date of each event instead of flags (Y/N) ? Would you still keep this dates within a junk dimension?

Sure, why not. But, as a best practice, it will not be included with the main junk dimension table (lets […]
December 22, 2016

What is a Junk Dimension in Data warehouse?

As per Kimball Group, a junk dimension combines several low-cardinality flags and attributes into a single dimension table rather than modeling […]