Mapping a data from a data warehouse to a data mart

摘要

A method and system and a computer program are provided for allowing users to extract predetermined, specialized content out of an Online transaction processing system (OLTP) into the portfolio management system database using data warehouse as a filtering device in an integrated database system. The use of the data warehouse as a filter involves determining a data structure representation for data sets stored in the data warehouse that conforms to the portfolio management system database schema, mapping data structure defined in the data warehouse schema to data structure supported by the portfolio management database and extracting predetermined data sets for use in the future processes. <IMAGE>