Pentaho Data Integration

CloudLabs

Projects

Assignment

24x7 Support

Lifetime Access

.

Course Overview

Improve productivity by giving your data integration team the skills they need to succeed with Pentaho Data Integration.Instead of coding in SQL or writing MapReduce Java functions, you can immediately gain real value from data, including from multiple sources like Hadoop, NoSQL and relational data stores, using an easy to use graphical designer.Learn to deliver data to a wide variety of applications using Pentaho’s out-of-the-box data standardization, enrichment and quality capabilities

At the end of the training, participants will be able to:

Pre-requisite

  1. Strong understanding of SQL and relational database.
  2. A basic knowledge of web-applications is also suggested. The final session requires a strong understanding of HTML and HTML authoring techniques.

Duarion

5 days

Course Outline

  1. Introducing Pentaho Data Integration
  2. Inputs and Outputs
  3. Introduction To The Training Data
  4. Data Warehouse Steps 
  1. Lookups
  2. Field Transformations
  3. Set Transformations
  4. Pivot Transformations
  5. Field Transformations, Part 2
  6. Loading The Time Dimension and Fact Table 
  1. Introduction To Jobs
  2. Advanced Job Concepts
  3. Common Scripting Uses
  4. Dynamic Transformations
  5. Using XML In Pentaho Data Integration
  6. Portable Transformations and Jobs
  1. Logging
  2. Error Handling in Transformations
  3. ETL Patterns
  4. Pentaho Enterprise Repository
  5. Scheduling and Monitoring
  6. Pre And Post-Processing
  7. Tuning and Administration Topics
  8. Interpreting Runtime Data
  9. Clustering and Partitioning
  10. Operational Patterns

Reviews