Title :
Data Migration from a Product to a Data Warehouse Using ETL Tool
Author :
Shrinivasan, Chandrika
Author_Institution :
Tata Consultancy Services Ltd., London, UK
Abstract :
One of emerging trends in today´s market is usage of products for core business operations instead of using homegrown code. Migration from application to a new product or from one product to another is considered very risky. Each product will not expose their underlying database due to Intellectual property rights (IPR). This paper attempts to describe an approach used for migration of historical data from a risk management product to a data warehouse product and setting up a daily feed from the product into the data warehouse to have previous day reports available for current day trading.
Keywords :
business data processing; data handling; data warehouses; industrial property; risk management; ETL tool; data warehouse product; historical data migration; intellectual property rights; risk management product; Data models; Data warehouses; Databases; Europe; Risk management; Testing; ETL; Informatica; agile methodology; data migration; product migration;
Conference_Titel :
Software Maintenance and Reengineering (CSMR), 2010 14th European Conference on
Conference_Location :
Madrid
Print_ISBN :
978-1-61284-369-8
Electronic_ISBN :
1534-5351
DOI :
10.1109/CSMR.2010.25
