The Data Warehouse ETL Toolkit comprehensively covers the entire process of effectively building and managing a data warehouse. The book includes pragmatic solutions for the most time and labor intensive stage of data warehousing, Extract-Transform-Load (ETL). read more...
The Data Warehouse ETL Toolkit is essentially a guide for novice as well as advanced data warehouse developers and managers. The book elaborates on the foundation of the data warehousing system known as the Extract, Transform, and Load (ETL) system. The ETL system is the backbone of any data warehouse and often consumes 70 percent of the resources required for the implementation and maintenance of a typical data warehouse. The book is organized around the four steps that are involved in the ETL system viz. extraction of data from the source systems, enforcing data quality and consistency standards, conforming data to facilitate the use of separate sources together, and finally delivering data in a presentation-ready format that developers can use to build applications. The Data Warehouse ETL Toolkit describes the most efficient practices for data extraction from scattered sources throughout the enterprise, removal of redundancy and inaccuracy, transformation of resultant data into correctly formatted data structures, and finally physical uploading of the end product into the data warehouse. The book also includes useful ETL techniques to save time, a comprehensive guide on building dimensional structures and practical advice on maintaining data quality. short..
|Publisher||Wiley india Pvt. Ltd|
|Imprint||Wiley india Pvt. Ltd|
|Number of Pages|