EXTRACTION, TRANSFORMATION AND LOADING PROCESSThe
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.
|
|
|