Técnicas para capturar cambios en los datos y mantener actualizado un almacén de datos

Abstract

During the extraction, transformation and loading processes it is critical to keep updated the data warehouse and data marts. In practice, several techniques that can b e used to capture changes in the data are available. Although from the theoretical point of view these techniques have been studied,in practice its form of use is not visualized in an organized way. Therefore,it is necessary to characterize, compare them and select the most appropriated. Given the simplicity aspects, types of sources that can be used, operations it can detect and no loss of information, it was chosen the technique based on snapshot as the most appropriate d. In addition a set of steps was proposed to follow for application to a real problem, suggesting the use of steps belonging to the data integration tool Pentaho Data Integration.

Keywords

• CDC techniques
• data mart s
• data warehouse
• ETL
• snapshot