Abstract

The extract, transform and Load (ETL) tool is extracting data from multiple, heterogeneous data source, transforming data, and finally loading data into the data warehouse. It is the foundation of any data warehouse, data mining and business intelligence. The land and resources system usually adopts star schema database, so it is difficult to transform the data from source database to target warehouse. This paper research the key technologies of ETL, including data extracting,data transforming, data incremental loading and break-points transmission.

Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call