ETL – Extract, Transform and Load

ETL is the most important term when it comes to database and Data Warehousing. ETL stands for Extract, Transform and Load. ETL covers a process of how the data are loaded from the source system to the data warehouse. ETL can be called as the pipeline between two databases or…

Continue reading

What is Data Mart ?

Data Mart is very similar to a Data Warehouse but limited in scope and purpose and is usually associated to one single domain. Often people get confused between Data Warehouse and Data Marts. I have already written before about the Data Warehouse and need of Data Warehouse. If you have missed…

Continue reading

OLAP – Online Analytical Processing

Due to the increase in data volumes and the recognition of the business value of analytics, OLAP (Online Analytical Processing) has become very popular . OLAP allows users to analyze database information from multiple database systems at one time. So in this article i will tell you about the different aspects of…

Continue reading