数据转换服务(DTS)技术在数据仓库中的运用

Application of data transformation serverices technology in the data warehouse

学校的业务系统是在不同时期、不同背景、面对不同应用、不同开发人员等各种客观前提下建立的,其数据结构、存储平台、系统平台均存在很大的差异,所以学校各种源数据缺少统一的标准,数据难以转化为有用的信息,原始数据的不一致导致决策的可信度的降低.在此着重介绍了在数据仓库中数据转换服务(DTS)技术对不同数据源的数据进行转换,使得最终实现数据完整性和一致性.

This article is about the establishment of data warehouse based on each department in our school. The internal storage data of data warehouse are from various transactions processing system of the schools and external data sources. The school system is operating at different times, different backgrounds, different application and different developers, and data structure, storage platform, the platform system are very different, so the school＇s source data lack a uniform standard, which is hard to transfer to useful information, and raw data of inconsistencies lead to reduction of the credibility of the decision support system. This article introduces Data Transformation Services （DTS） technology in the data warehouse, which transfers different data sources to make the realization of data integrity and consistency of the unity.