What is Data Lake ?
We are living in the age of digital transformation when voluminous data is getting created in diverse forms and shape. Every business is trying to...
What is Change Data Capture ?
In this digital age of data, if you are working with data day in and day out, you would have definitely come across the term...
Introduction to Data Mining
World is now running on data. Once we get up in the morning and go back to bed in night, our life is related to...
Bottom Up Vs Top Down Approach in Data Warehouse
To build a successful data warehouse, data warehouse design is the key technique. To save the time and cost , it is must to choose...
Why Informatica is best ETL tool ?
ETL tools are required to extract, transform and load the data to Data Warehouse. ETL tools are the key to handle the database and Data...
How to Choose Right ETL tool ?
So you planning to build Data Warehouse? But not able to decide which is the right ETL tool for you business.I can understand your confusion...
Pentaho Data Integration(PDI)
Pentaho Data Integration(PDI) is the most powerful open source ETL tool available in market. It is one of the important tools available in Pentaho BI...
Slowly Changing Dimension SCD
In Data Warehouse, problem of slowly changing dimension is a common one. This applies to cases where the attribute for a record varies over time. Today...
Types Of Fact
Till now, we have already discussed about types of dimension. So lets move to another concept in dimensional modelling, i.e, FACT . A fact is a...
Types of Dimension
Dimensional modelling has two basic concepts – fact and dimension. Dimensions store the textual descriptions of the business attribute. Without the dimensions, we cannot measure...