Transformation is regarded as the major part of the ETL process, where all the extracted data is cleansed and transformed into the appropriate detail for the final loading into the data warehouse. Starting with cleansing the data, when loading data from a number of different transaction systems, it is important to go through the following [...]

In this post I would like to describe some of the important tasks and considerations when developing a reliable extract – transform & load process as part of your data warehousing project. In a previous post, I described Data warehousing (DWH) “as the means with which data is delivered from different operational systems such as [...]

As Business Management noted recently, we live in an information economy, and “smart use of information and information technology can be one of the most effective ways to gain a competitive advantage and thrive in times of change”. Business (BI) intelligence and data warehousing (DWH) are two important terms as regarding using information for decision [...]

Recently I attended a Microsoft SQL academy presentation given by Bob Duffy where SQL Server 2008 R2 was previewed with screenshots as there is no technology preview available yet. SQL 2008 R2 release is planned for general release sometime in the first half of 2010 and here are some interesting features that I took away [...]