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 17, 2017
Fact tables

Add columns to a fact table in the Data Warehouse

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
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 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 […]
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 […]
October 25, 2016

What is dimension table in data warehouse?

Dimension table contains the descriptive information about the numerical values in the fact table, i.e they contain the attributes of […]
October 25, 2016

What is fact table in data warehouse?

Fact table contains numerical values which can be measured. Hence these are also called as measures. Basically, these are nothing […]
May 24, 2016

Differences between ER Modeling and Dimensional Modeling

March 26, 2016

Differences between OLTP, OLAP, ODS, DWH and DSS systems (Infographic)

January 9, 2016

FAQs for BI Architecture

What is a Data Warehouse? A data warehouse is a central repository for all or significant parts of the data […]