Resumo

DIAZ-DE-LA-PAZ, Lisandra et al. Techniques to capture changes in data and keep updated a data warehouse. Rev cuba cienc informat [online]. 2015, vol.9, n.4, pp. 89-103. ISSN 2227-1899.

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 be 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 appropriated. 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.

Palavras-chave : CDC techniques; data marts; data warehouse; ETL; snapshot.

        · resumo em Espanhol     · texto em Espanhol     · Espanhol ( pdf )