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 derive more and more value out of…
Category: Data Warehouse
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 “Change Data Capture” (CDC) somewhere. The concept…
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 data in one or another way and…
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 right data warehouse design.In this post we…
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 Warehouse. There are number of good ETL…
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 because choosing the right ETL tool is…
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 Suite. Also known as ‘KETTLE’, Pentaho Data Integration(PDI)…
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 I will give introduction about slowly changing…
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 measure or metrics of business process. In…
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 the facts and facts are just disordered…