Extracting Method and Mappings for Heterogeneous Systems

Abstract

This paper defines how to select the correct method or combinations of methods to minimize the impact of production system and common operation. Before any method is chosen it is necessary to know the primary system and its databases structures for optimal use of the actual data structure setup and the best design for the ETL process. Usually databases structures are categorized into groups, which define their quality. Classification helps to find an ideal method for each group and thus design the solution of the ETL process with minimal impact on the data warehouse and production system.