Data Migration, if not handled properly, can lead to problems like data corruption or compatibility issues. Following some best practices would go a long way in avoiding such serious operational damages to the business. Read more
Data migration projects highlight serious data quality issues that too often lead to delayed projects and cost overruns. In extreme cases, poor data quality has led to the abandonment of new business initiatives. Environments where high volumes of data are entered into key business systems are a breeding ground for data quality problems. Lack of user knowledge, absence of stable and robust processes, and missing relationship linkages can lead to poor quality data in any system. The most common issues are: Read more
There are variety of tools available to use in the data migration process by both advanced and beginner developers. These tools are contingent upon the compatibility of the data environment and platform dependent.
Informatica Power Center – A functional programming tool for platform accessing, reporting and integrating data.
Ascential Data Stage – Provides OnDemnd data integration.
ESS Base Hyperion – Creates analytic and enterprise performance management applications.
Business Objects: Data Integrator – Builds data marts, ODS systems and data warehouses. Read more