ETL ELT architecture

What is ETL?

ETL defined Extract, Transform and Load  or ETL is a standard information management term used to describe a process for the movement and transformation of data. ETL is commonly used to populate data warehouses and datamarts, and for data migration, data integration and business intelligence initiatives. ETL processes can be built by manually writing custom scripts or code, with…

Four steps to transforming data

Another brief post this week on an area that we do not focus on very often: data transformation. Data transformation is a relatively mundane yet fundamental data management capability – particularly when dealing with similar data from multiple sources. Three simple examples: System A represents Male and Female and 0 and 1, while System B…

Data Integration can be cheap and easy

I recently discovered a new approach to data integration that I find really appealing. Instead of focussing on complex data integration issues and can focus on solving the business problem using data. And, best of all, it’s free! Traditionally, data integration applications are designed to be used in large IT infrastuctures and require highly skilled…