Size & Effort Estimation Model for ETL
This model will simplify and accelerate the process of size & effort estimation for ETL job development using a ETL tool. The purpose of this paper is to define a method for estimating ETL job development for DataStage / Informatica jobs by calculating job size and complexity based on the job pattern and specific challenges within the job. This Size & Effort Estimation model will help to predict how many Horizontal and vertical design blocks should be produced and how many developers are required and how long it will take. The approach is based on data typically produced during early stages of software development from various successfully executed projects.
Read more
Rock your Data Warehousing with SOA
The lazy big giant who serviced the BI world on a periodic basis is getting an overhaul. It’s all set to keep a finger on the pulse of business and ship all the different [BI] pieces that customers require. Service-oriented architecture makes room for data warehousing! This could be the beginning of a perfect marriage.
The relationship between data warehousing and SOA was always complicated. Opposite ends of a spectrum - aggregated vs. federated data, data centric vs. process centric. But how about bringing them together to deliver data as a service? The suitability of a service-oriented architecture (SOA) to transform data warehouses into information as a service is addressing this challenge, though with important conditions and qualifications.
Read more