摘要
针对数据迁移中ETL技术的实现问题,指出可以通过构造输入数据库和中间数据库,利用Datastage工具和PL/SQL程序相结合的方式进行数据迁移.给出了Datastage工具的应用策略和PL/SQL程序实现ETL过程的具体流程.实践表明该方案数据迁移速度较快,能够较好地完成海量数据的迁移任务.
The solutions are put forward for the implementation of ETL in the data migration. That is to construct the input database and middle database, and to transfer the Data with the Datastage and the program of PL/SQL. The application strategy of the datastage and the specific process of the program of PL/SQL are presented. The practice shows that the speed of data migration is fast and the task of massive data migration can be finished successfully.
出处
《西安工程大学学报》
CAS
2008年第4期493-497,共5页
Journal of Xi’an Polytechnic University
