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 [...]