Time to put the “T” back into ETL?
A hidden cost of ELT is the proliferation of costly database staging areas to do transformations. High performance ETL may be a better option
Simplify Big Data Development – Design Once, Deploy Anywhere
It’s certainly not a new refrain, but in recent years IT managers are increasingly being told to do more with less – even as the number of new projects and requirements increase. Data is the fuel that powers most new business initiatives, but each project needs a slightly different blend of data sources and data…
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…
