Monday, April 19, 2010

Informatica Incremental Aggregation

Saurav has posted a new article here on Incremental Aggregation Using Informatica.

The need of incremental aggregation arise when we capture our source data (transactional data) incrementally in a frequency faster than the aggregation period.

Take this example, a data warehouse system is refreshed every night from source data. The data warehouse has a monthly aggregated table. So it is obvious that every day's data you need to aggregate and put together in the monthly table. But in stead of loading the monthly table at month end, if you consider loading this monthly table everyday or every week or bi-monthly, then incremental aggregation is possibly the best option for you.

Now performance wise, it remains an open question on how good is Informatica in doing incremental aggregation. I think Saurav might consider an other article by putting informatica in test with considerable data volume.

Sunday, April 18, 2010

A List of the future articles scheduled to be published in

Following are the list of articles I am planning to publish in this April'10 in the site,

1. Detail Oracle Server Architecture
2. A list of common and effective Oracle hints
3. How to read and interpret AUTO TRACE result
4. Brief Oracle Index tutorial for the application developers

1. All about Informatica Partitioning
2. All about Informatica LookUps

Apart from these, I am also planning to introduce a new section on Data Warehousing Project Management in the site.

Let me know your comments..

Saturday, April 17, 2010

Companion Blog for

This blog is a companion blog for is a dedicated website created for the data warehousing practitioners around the world. Visit to read latest data warehousing news, articles, white papers and tutorials.

This blog will periodically post the links to the newly published contents in All the future releases, upcoming articles, major changes etc. can be viewed, requested or discussed here.
This blog can be used as an way for the users to communicate with the team behind