ETL现状与发展（ETL status and development）.docVIP

ETL现状与发展（ETL status and development） Details: current status and development of ETL The information system that BI operation relies on is a complex data set made up of traditional system, incompatible data source, database and application. Each part can not communicate with each other. From this perspective, the current application system is the enterprise in a great effort and financial resources to build, irreplaceable system, especially the system data. The new BI system aims to assist decision-making through data analysis, but the source and format of these data are different, which leads to the difficulty of system implementation and data integration. At this time, the enterprise hopes to have a very comprehensive solution to extricate oneself from a predicament, to solve the data consistency and integration problems, which can collect data from the traditional environment and platform, and use a single solution for efficient conversion of the. The solution is ETL (extraction, transformation, and, loading). Usually, the enterprise data sources distributed in each subsystem and the node, ETL will use the local business system data, through automatic or manual control to FTP UNIX or NT server for data acquisition, conversion, and then stored in the data warehouse. Because the existing business data source, to ensure the consistency of data, truly understand the meaning of data across business, multi platform, multi system integration data, and can improve the quality of the data, to meet the changing needs of business characteristics, which is the key of ETL technology. To be sure, ETL runs through the entire BI solution and completes data processing and scheduling throughout the system. Data acquisition The data acquisition is mainly for various business systems and data of different outlets, fully understand the data definition, data source and data definition planning needs, and further through the data source to obtain the desired data. Determining how to obt