pentah的o kettle solution.docxVIP

Pentaho kettle solution Pentaho kettle solution：building open source etl solution with pentaho data integration。 This book will teach you: 1. 数据集成是什么，为什么需要。 2. The concepts that form the foundation of the Kettle solution，形成kettle解决方案基础概念。 3. How to install and configure kettle ,both on a single computer and a client/server environment.(客户机和服务器在一台计算机上) 4. How to build a complete end-to-end ETL solution for the MySQL Sakila demo database（利用mysql数据库进行演示） 5. What the 34 subsystems of ETL are and how they translate to the Kettle toolkit。 6. How Kettle can be used for data extraction, cleansing and conforming, handling dimension tables,loading fact tables, and working with OLAP cubes（利用OLAP立方体处理纬表，装在事实表） 7. What the Kettle development lifecycle looks like 8. How to take advantage of Pentaho’s Agile BI tools from within the Kettle development environment 9. How to schedule and monitor jobs and transformations（预订并监控任务和转换） 10.How to work with multiple developers and manage different versions of an ETL solution（用多种开发商和控制不同版本的etl） 11. What data lineage, impact analysis, and auditing is, and how Kettle supports these concepts 12. How to increase the performance and throughput of Kettle using partitioning, parallelization, and dynamic clustering （如何提高kettle使用分区、并行化、动态聚类的性能和吞吐量） 13. How to use complex files, web services, and web APIs 14. How to use Kettle to load an enterprise data warehouse designed according to the Data Vault principles15.How to integrate Kettle with other solutions and how to extend Kettle by developing you own plugins 章节一 主要的介绍在数据集成工程中主要的概念和未来的展望，解释事务处理与分析系统之间的不同之处，以及在etl中的配合（fits in），并且讲述一个etl解决方案如何在各部门（components）解决数据集成问题（data-integration problems） 章节二 *we explain the basic building blocks(基础)，consisting of jobs,transformations,stepl,and hops,and how they interact(互动) with each other.当然也可以学习kettle如何interacts 和databases,还有（this can be influenced by setting database-specific options）数据库选项设置的影响,this chapter also contains A hands-on(动手) mini tutorial（教程） to