Category: Information System

Data warehouses and what the future holds

Data warehouses are designed in such a way that they are optimised for speed of data retrieval. To assist in speeding data retrieval, the data stored in the data warehouse is often stored multiple...

Why Use ETL?

ETL stands for extract, transform and load. These are the processes that enable companies to move required data from a multitude of sources, reformat and cleanse it, and then load it into a data...

The problem of dirty data

What is Dirty Data? Before we get into how to deal with dirty data let us define exactly what it is. Dirty data is a term used to refer to information/data that is misleading,...

What is Etl & Datawarehouse?

You probably heard about datawarehouses & analysis tools in the past in database related discussions or in job meetings. The fact is that everyday more and more companies are starting to think (and build)...