상세정보
Export to Refworks부가기능
Pentaho data integration quick start guide : create ETL processes using Pentaho
상세 프로파일
| 자료유형 | 단행본 |
|---|---|
| 서명/저자사항 | Pentaho data integration quick start guide : create ETL processes using Pentaho/ Mari?a Carina Rolda?n. |
| 개인저자 | Rolda?n, Mari?a Carina,author. |
| 발행사항 | Birmingham, UK: Packt Publishing, 2018. |
| 형태사항 | 1 online resource (1 volume): illustrations. |
| 기타형태 저록 | Print version: Rolda?n, Mari?a Carina Pentaho Data Integration Quick Start Guide : Create ETL Processes Using Pentaho Birmingham : Packt Publishing Ltd,c2018 9781789343328 |
| ISBN | 9781789342796 1789342791 |
| 내용주기 | Cover; Title Page; Copyright and Credits; Dedication; Packt Upsell; Foreword; Contributors; Table of Contents; Preface; Chapter 1: 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; Chapter 2: Extracting Data Getting data from plain filesReading 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; Chapter 3: Transforming Data; Transforming data in different ways Extracting data from existing fieldsMore 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; Chapter 4: 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 stepLoading a dimension with a dimension lookup/update step; Loading a fact table; Summary; Chapter 5: 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 |
| 요약 | Chapter 6: Getting Started with PDI; Introducing PDI; Installing PDI; Configuring the graphical designer tool; Creating a simple transformation; Understanding the Kettle home directory; Summary; Other Books You May Enjoy; Index |
| 요약 | Pentaho Data Integration(PDI) is an intuitive and graphical environment packed with drag-and-drop design and powerful Extract-Transform-Load (ETL) capabilities. Given its power and flexibility, first attempts to use the Pentaho Data Integration tool can be difficult or confusing. This book is the ideal solution to that problem. |
| 일반주제명 | Data integration (Computer science) Data mining. Decision support systems. Database management. COMPUTERS / Databases / General. Computers --Programming Languages --Java. Operational research. Programming & scripting languages: general. Information visualization. Computers --Enterprise Applications --Business Intelligence Tools. Enterprise software. |
| 언어 | 영어 |
| 바로가기 |  |
