Home Page Icon
Home Page
Table of Contents for
Pentaho Data Integration Quick Start Guide
Close
Pentaho Data Integration Quick Start Guide
by Maria Carina Roldan
Pentaho Data Integration Quick Start Guide
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
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset