ETL Process Model for a Manufacture Cells Production Line Integration

This article describes a Causal Analysis and Resolution of a problem for the elaboration of a Data Mart - DM specialized in Production Control and Planning - PCP. The unified information in the proposed DM is loaded form Management Information Systems - MIS, with historic data from software development project. To allow the integrated load from different data sources, it was developed a Extract, Transform and Load - ETL process, whose implementation has integrated data from the MIS of Function Point Analysis and Personal Software Process - PSP in a software factory. That allowed the construction of a Decision Support System - DSS over the constructed DM. This DSS allows the use of Online Analytical Processing - OLAP to support quantitatively the Process Areas of Measurement and Analysis - MA of Capability Maturity Model Integration - CMMi.