Join the Community

Sponsor

Newest Articles

Also Read

Free BI Digest

Need more help on this subject?

Ask a question

Tutorials on the basic concepts and theories behind ETL (Extraction, Transformation and Loading) technology.

Why do we need Staging Area during ETL Load

Details
Category: ETL Concepts
Last Updated on Tuesday, 18 September 2012 09:28
Written by Akash Mitra

"We have a simple data warehouse that takes data from a few RDBMS source systems and load the data in dimension and fact tables of the warehouse. I wonder why we have a staging layer in between. Why can’t we process everything on the fly and push them in the data warehouse?"

Read more: Why do we need Staging Area during ETL Load

Incremental Loading for Fact Tables

Details
Category: ETL Concepts
Last Updated on Tuesday, 05 June 2012 04:09
Written by akash

In the previous articles, we have discussed the general concepts of incremental data loading as well as how to perform incremental data loading for dimension tables. In this article we will discuss the methods and issues of loading data incrementally in Fact tables of a data warehouse.

Read more: Incremental Loading for Fact Tables

Methods of Incremental Loading in Data Warehouse

Details
Category: ETL Concepts
Last Updated on Tuesday, 15 May 2012 12:10
Written by akash

Incremental loading a.k.a Delta loading is an widely used method to load data in data warehouses from the respective source systems. This technique is employed to perform faster load in less time utilizing less system resources. In this tutorial we will understand the basic methods of incremental loading.

Read more: Methods of Incremental Loading in Data Warehouse

Incremental Loading for Dimension Table

Details
Category: ETL Concepts
Last Updated on Tuesday, 15 May 2012 11:35
Written by akash

In our previous article we have discussed the concept of incremental loading in general. In this article we will see how to perform incremental loading for dimension tables.

Read more: Incremental Loading for Dimension Table

Building the Next Generation ETL data loading Framework

Details
Category: ETL Concepts
Last Updated on Saturday, 03 March 2012 02:54

Do you wish for an ETL framework that is highly customizable, light-weight and suits perfectly with all of your data loading needs? We too! Let's build one together...

Read more: Building the Next Generation ETL data loading Framework