舉報

會員
Pentaho Data Integration Quick Start Guide
PentahoDataIntegration(PDI)isanintuitiveandgraphicalenvironmentpackedwithdraganddropdesignandpowerfulExtract-Transform-Load(ETL)capabilities.Givenitspowerandflexibility,initialattemptstousethePentahoDataIntegrationtoolcanbedifficultorconfusing.Thisbookistheidealsolution.ThisbookreducesyourlearningcurvewithPDI.Itprovidestheguidanceneededtomakeyouproductive,coveringthemainfeaturesofPentahoDataIntegration.Itdemonstratestheinteractivefeaturesofthegraphicaldesigner,andtakesyouthroughthemainETLcapabilitiesthatthetooloffers.Bytheendofthebook,youwillbeabletousePDIforextracting,transforming,andloadingthetypesofdatayouencounteronadailybasis.
目錄(100章)
倒序
- 封面
- Title Page
- Copyright and Credits
- Pentaho Data Integration Quick Start Guide
- Dedication
- Packt Upsell
- Why subscribe?
- PacktPub.com
- Foreword
- Contributors
- About the author
- About the reviewer
- Packt is searching for authors like you
- Preface
- Who this book is for
- What this book covers
- To get the most out of this book
- Download the example code files
- Download the color images
- Conventions used
- Get in touch
- Reviews
- Getting Started with PDI
- Introducing PDI
- Installing PDI
- Configuring the graphical designer tool
- Creating a simple transformation
- Understanding the Kettle home directory
- Summary
- Getting Familiar with Spoon
- Exploring the Spoon interface
- Designing previewing and running transformations
- Designing and previewing a transformation
- Understanding the logging options
- Understanding the Step Metrics tab
- Dealing with errors while designing
- Saving and running a transformation
- Defining and using Kettle variables
- Using named parameters
- Running transformations with the Pan utility
- Summary
- Extracting Data
- Getting data from plain files
- Reading plain files
- Reading files with great versatility
- Reading files from remote locations
- Reading files from Google Drive
- Getting data from relational databases
- Connecting to a database and using the database explorer
- Getting data from a database
- Getting data from other sources
- XML and JSON
- System information and Kettle variables
- Combining different sources into a single dataset
- Manipulating the metadata
- Combining two different datasets into a single dataset
- Summary
- Transforming Data
- Transforming data in different ways
- Extracting data from existing fields
- More ways to create new fields
- Sorting and aggregating data
- Sorting data
- Aggregating data
- Filtering rows
- Filtering rows upon conditions
- Splitting the stream upon conditions
- Looking up for data
- Looking for data in a secondary stream
- Looking up data in a database
- Summary
- Loading Data
- Generating different kinds of files
- Inserting and updating data in database tables
- Inserting data
- Updating data
- Handling errors
- Loading a datamart
- Loading a time dimension
- Loading other kinds of dimensions
- Loading a dimension with a combination lookup/update step
- Loading a dimension with a dimension lookup/update step
- Loading a fact table
- Summary
- Orchestrating Your Work
- Understanding the purpose of PDI jobs
- Designing and running jobs
- Creating and running a simple job
- Understanding the results of execution
- Sequencing tasks
- Taking a tour of the job entries
- Sending emails
- Combining the execution of jobs and transformations
- Executing transformations from a job
- Creating user-defined Kettle variables
- Nesting transformations and jobs
- Running jobs with the Kitchen utility
- Summary
- Other Books You May Enjoy
- Leave a review - let other readers know what you think 更新時間:2021-07-16 17:59:25
推薦閱讀
- 韌性:不確定時代的精進(jìn)法則
- 激發(fā)力:打造激情四射的團(tuán)隊
- HR招聘實務(wù)手冊
- 拓客:實體店引流99招
- 現(xiàn)代企業(yè)管理探索與實踐
- 2018—2019年中國戰(zhàn)略性新興產(chǎn)業(yè)發(fā)展藍(lán)皮書
- 世界500強(qiáng)企業(yè)崗位執(zhí)行標(biāo)準(zhǔn)
- 生產(chǎn)性服務(wù)業(yè)創(chuàng)新發(fā)展知識干部讀本
- 世間所有的無眠,都是因為睡錯了風(fēng)景
- 管理的實踐(全新譯本)
- 商戰(zhàn)
- 危機(jī)公關(guān)實戰(zhàn)手冊
- 奮斗之光:華為內(nèi)部訓(xùn)練與激勵法則
- 餐飲管理職位工作手冊
- 有效率的專利聯(lián)盟:競爭效應(yīng)和創(chuàng)新效應(yīng)研究
- 企業(yè)文化
- 給你一個公司,看你怎么管
- 明星員工的思維模型
- 中國上市公司年報文本信息披露特征、生成機(jī)制與經(jīng)濟(jì)后果:基于同伴效應(yīng)的研究
- 打造一流中層
- 生活之余還可以創(chuàng)業(yè)(共九冊)
- 狼性商鑒
- 管理溝通:理論、案例與實訓(xùn)(微課版 第2版)
- 中國溢價:透視中企海外并購
- 管理學(xué)理論與實務(wù)
- 卓越小公司的成功商道
- 企業(yè)的人性面
- 喚醒空間生產(chǎn)力
- 成功創(chuàng)業(yè)的300個常識
- 盲點(diǎn):聰明人都在做你想不到的事