November 22, 2017
Degenerate Dimension

Where will the Degenerate Dimension’s data stored?

October 13, 2017
Primary Key Vs Surrogate Key

What is the difference between Primary Key and Surrogate Key?

September 18, 2017

Data Warehouse Vs Business Intelligence

May 29, 2017
Datawarehosue

Why denormalized data is there in Data Warehosue and normalized in OLTP?

May 29, 2017
Dimensions

Is there any limit on number of Dimensions as per general or best practice for a Data Warehouse?

March 8, 2017

What is the difference between Data Warehouse and Business Intelligence?

February 21, 2017
Data Mining

Data Mining

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 […]
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 […]
January 20, 2017

Transactional, Master and Reference Data explained

Transaction data keeps on changing and deals with day to day activities carried out in business or different departments. For […]
January 19, 2017
Data Extraction Methods

Different Data Extraction Methods in an Enterprise DataWarehouse

Online Extraction: In this method, the data is extracted directly from the Source for processing in the staging area (based […]
January 7, 2017
Repository Database

Use of an ODS in conjunction with a DWH

ODS plays a dual role, it is operational, providing high response time and availability and is certainly qualified to act […]
January 7, 2017
ODS vs Staging

Staging vs ODS

ODS can be considered as a staging area as the data can be stored here temporarily (about 45 to 60 […]
January 5, 2017
Data Cleansing

What is the actual difference between Data cleansing and Data scrubbing?

There can be many interpretations and often we get into a discussion/confusion that these are the same with different naming […]
December 24, 2016
Data Replication

We know that Data Warehouse is loaded from staging tables, then same data will be present at both the places for same time period, unnecessarily creating duplicate dataset. Can’t we have any other method to avoid this?

Its not always mandatory or true to have the same data in staging and in the Data Warehouse. You can […]
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 24, 2016
multiple data stages

Instead of having multiple staging tables, can I stick with only one and do all my validations in the memory and insert the data to the star schema?

Yes, you can. End of it, these are relational and would work as we code and design them. We can […]
October 25, 2016

DataMart Vs Data Warehouse

Sam started his startup and over the years the startup has brown big and become an enterprise with multiple outlets […]