EXTRACTION, TRANSFORMATION AND LOADING PROCESS
The Extraction, Transformation and Loading process usually constitutes 60% – 70% of the effort in a business
intelligence project. Get this wrong and you’ll get the project wrong. A well architected warehouse or an
elegant looking report isn’t worth much if the information content is either incorrect or irrelevant.
We have deep expertise in ETL and have developed our own internal standards for programming, job design and overall
process control. These standards are the result of the years of experience gained on several large projects.
Good use of these standards translates to ETL stages that are:
- Quick to develop
- Accurate in the data to information transformation
- Less error prone
- More maintainable and staff independent.
|
|
|