A successful migration of the large information system is based on the correction of data transformed from the old platform to the new platform. Because software and hardware technology grew rapidly, the elimination frequency of information system is increased. It also raises the importance of data migration and transformation. ETL (Extract-Transform-Load) is a process that describes data be extracted, transformed, and loaded from source to target. It defines the operation process content for each stage in the data migration and transformation. ETL provides a leading method and flow. It also raises the success rate of data migration and transformation. The thesis based on ETL theory and developed a customized software tool of data migration and transformation for large information system. We provided research and implementation experience for data migration and transformation. Let it being able to grown up with software and hardware technology in the future. The research includes ETL description, consideration of choosing ETL, ETL design and implementation, and the consideration of ETL execution.
ETL (Extract-Transform-Load) Parallel-Process Extract Transform Load